| From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
|---|---|
| To: | "Michael Glaesemann" <grzm(at)seespotcode(dot)net> |
| Cc: | "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>, "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>, "Ron Johnson" <ron(dot)l(dot)johnson(at)cox(dot)net>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Views- Advantages and Disadvantages |
| Date: | 2007-05-09 20:18:22 |
| Message-ID: | D425483C2C5C9F49B5B7A41F8944154701000642@postal.corporate.connx.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> -----Original Message-----
> From: Michael Glaesemann [mailto:grzm(at)seespotcode(dot)net]
> Sent: Wednesday, May 09, 2007 12:14 PM
> To: Dann Corbit
> Cc: Ashish Karalkar; Andrej Ricnik-Bay; Ron Johnson; pgsql-
> general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Views- Advantages and Disadvantages
>
>
> On May 9, 2007, at 14:02 , Dann Corbit wrote:
>
> > Views can hide important information from the optimizer (especially
> > index information).
>
> Really? AIUI, views-at least in PostgreSQL-are implemented using
> PostgreSQL's rule system: the entire query is rewritten to include
> the view query, and the optimizer sees the rewritten query. What the
> optimizer sees is the same as if the view were inlined in the
> original query.
That is a significant achievement, since many database systems do not
have that ability.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John DeSoi | 2007-05-09 20:19:47 | Re: User restrictions |
| Previous Message | Tilmann Singer | 2007-05-09 19:26:09 | Re: Audit-trail engine: getting the application's layer user_id |