I have a view that I am building that uses left outer joins to combine multiple views and tables. Up to a point of adding addition (needed) views and tables to this join it will execute in about 1:40 sec, and returns about 850 rows, but if I add just one more table/view then the execution time goes to over 30 minutes and still running. I have tried replacing/substituting different tables/views in the join, but nothing seems to help. Does anyone have any idea of what could possibly be happening to me?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
view generation script execution time
- Thread starter tmartin99
- Start date
Try taking the query and pasting into Query Analyzer, then viewing the Graphical Execution Plan. Look for processes that have a high % value, and try to figure out ways to attack that particular process (adding an index, etc). -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:
- Status
Similar threads
- Locked
- Question
- Locked
- Question