March 23, 2012 at 12:46 pm
Hello Folks..
I have one query sometimes taking long time to execute and when i checked with execution plan it suggest me to create no clustered index.
Now when i saw the tables used that query, doesn't have clustered index also .
And that query is executing by application like every 5 second.
So any suggestion please?
Thank you
March 23, 2012 at 12:50 pm
We can't see from here what you see from your desk. If you knew nothing of the problem, could you help someone given the information you just gave us?
March 23, 2012 at 1:27 pm
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Also read through these:
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 23, 2012 at 2:46 pm
First you need to determine if you have a good candidate for a clustered index. Check out Kimberly Tripp's blog for this. Here's the last post, http://www.sqlskills.com/BLOGS/KIMBERLY/post/The-Clustered-Index-Debate-again!.aspx in group about indexes that includes links to the others she has written. If you have a good candidate for a clustered index create it.
ONce you determine that then you can decide what non-clustered indexes you might need based on how the table is accessed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 23, 2012 at 3:02 pm
Thanks Jack ..really helpful to me
Have a good weekend
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply