Steve Jorgensen (nospam@nospam.nospam) writes:
> That brings to mind a useful optimization idea. What if SQL Server
> could ignore M-1 outer joins when the results from the secondary table
> are not used ore returned? Thus, if we SELECT a subset of fields from a
> view, unnecessary parts of the view query could be skipped.

I would expect the optimizer to be able to draw such conclusions.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp