David Lewis
DavidL at sierranevada.com
Wed Apr 5 12:55:34 CDT 2006
Well, there is a lot there to begin to look through... One thing that sticks out is the "SELECT TOP 100 PERCENT" in the underlying view. Remove that and the "ORDER BY" clause and you will do much to streamline the execution of the view. Also consider making as many of the queries covered as possible by either adding indexes or removing columns from the views that are not needed in the final query. I am not very experienced with streamline execution plans by optimizing joins, but I do try to read what comes my way and I have read that all joins are NOT created equal. Because your joins are relatively complex, it may be that there is much to do in that area. When I find a good reference I will pass it on... D. Lewis