Scan Density Question
-
We've got a table with six non-clustered indexes. Three of which have a scan density of 100% and the others are below 30%. We've tried to reindex and indexdefrag but to no avail, the scan density is still at less than 30%.
How can we get the scan density to increase? Any help would be greatly appreciated.
-
- First I would go for an extra sp_updatestats and dbcc UPDATEUSAGE (0)
- Do you also have a clustering index ?
- wich version of sqlserver are you using ?
- can you post the showcontig result(s) ?
- can you post any ddl ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
R u facing any issue if the scan dnsity is 100% ??moreover If you have are more updates in your production database server tables then it is better to minimize the number of non clustered index..coz whenever you are updating your rows you have to update the index also..one clustered index can be included by ALTER TABLE TABLENAME WITH NOCHECK ADD
CONSTRAINT PRIMARYKEYNAME PRIMARY KEY CLUSTERED
( COLUMN 
REGARDS,
VINOD
HTC GLOBAL SERVICES(09840856202)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply