March 13, 2008 at 1:06 pm
I have a table with one non cluster index. The scan density of the index is 100 but
the table scan density is 50. How to improve the table scan density.
I run the following command to get the scan density
dbcc showcontig ('error_log') with TABLERESULTS,ALL_INDEXES
Thanks
Hamma khan
March 13, 2008 at 1:30 pm
you could create a clustered index and drop it back again.
Keep in mind this will rewrite your table data twice ! as well as the index data.
If you can pick a unique column for this dummy operation !
Maybe, if this table has only one index, if it is a unique index, alter that one to clustered.
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
March 13, 2008 at 9:07 pm
If your table has one index, it should be a clustered index.
"Problems with not having a clustered index"
http://www.sqlservercentral.com/articles/Performance+Tuning/clusterthatindex/952/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply