Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

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?
0
ac_davis2002
Asked:
ac_davis2002
1 Solution
 
jogosCommented:
<<.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
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now