Posted by --CELKO-- on 04/04/06 06:04

>> Unfortunately, the optimizer won't push the highly selective predicate down the view's definition, so the query will run very slowly. However, if you rewrite the query without using the view, the optimizer will choose a better plan using the index on last_name. <<

Ingres usually gets the in-line code expansion right. DB2 is now just
about as good, with Oracle doing some things for sharing materialized
VIEWs among sessions. When you have "end of the month" VIEWs, it makes
a big difference.

>> One may hope that eventually SQL Server will ahve a better implementation of views, but for the time being in a SQL Server environment I would use views in moderation <<

When you see what Oracle and DB2 can do with VIEWs because they are
aiming at the enterprise level and not the departmental level, it is
really impressive.

[Back to original message]