We help IT Professionals succeed at work.

view time out

hi

I have a view that is timing out, i think it because of the fact it joins to 5 other views to get the results...is there a simple way i can speed it up?
Comment
Watch Question

Commented:
<<.is there a simple way i can speed it up?>>
Tune each view
If possible even look if there are overlaps in the views so a rewrite of the functionality of 2 views in one select could be more efficient.
Why a view now? Could it be a stored procedure (with or without parameters)?
Look for missing indexes or columns that can be included in an index to become a covered index.

Start at looking at the estimated execution plan, see some links
http://www.codeproject.com/Articles/9990/SQL-Tuning-Tutorial-Understanding-a-Database-Execu
http://msdn.microsoft.com/en-us/library/ms188722.aspx
http://msdn.microsoft.com/en-us/library/cc645887.aspx
http://sqlserverpedia.com/wiki/Examining_Query_Execution_Plans

Explore More ContentExplore courses, solutions, and other research materials related to this topic.