Re: 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.

Michael Glaesemann
grzm seespotcode net