| From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
|---|---|
| To: | Tomasz Myrta <jasiek(at)klaster(dot)net> |
| Cc: | Ries van Twisk <ries(at)jongert(dot)nl>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: To use a VIEW or not to use a View..... |
| Date: | 2003-01-22 17:30:47 |
| Message-ID: | 3E2ED547.DF9F68D4@Yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Tomasz Myrta wrote:
>
> Jan Wieck wrote:
>
> >Use tables, views and views over views, it's all fine and your indexes
> >will be used.
>
> I can't agree with using views over views. It has some limitations.
> I asked about it on this list several months ago
> and Tom Lane's conclusion was:
It has less to do with the nesting level of rewriting, than with what
you do with the view in general. If you cram up all the functionality
with aggregating subselects into one monster view it might do better,
except for maintaining the code.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomasz Myrta | 2003-01-22 18:38:30 | Re: To use a VIEW or not to use a View..... |
| Previous Message | Stephan Szabo | 2003-01-22 17:09:14 | Re: To use a VIEW or not to use a View..... |