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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
