Donnie Carvajal (8/1/2013)
I've updated the statistics on all of the underlying tables and the estimated rows are at 207077. Any other suggestions? I've attached the new .sqlplan.BTW, all of these views are made up of joins on other views. Is this bad practice?
Thanks again,
Donnie
Generally it is not a great idea to nest views on top of views. You can end up with really bad performance issues. I would recommend using Lowell's example of updating stats on all the tables in your db.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/