var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Choosing the right index
I had been working on some index tuning recently and I need some help understanding the output of sys.dm_db_index_usage_stats, here is the output:
Which is the best candidate for a clustered index and how would I know?
INDEX USER_SEEKS USER_SCANS USER_LOOKUPS USER_UPDATES
IDX_2 34184116 303843 0 650048
PK_1 51485628 8341065 22404041 2774943
UC_3 2130091 724511 0 2081603
What else does the output tell me?
Last edited by SQLSlammer; 06-23-09 at 08:34.
hmm and how do I post the output so it's readable, if I edit the post it is all lined up perfectly but doesn't reflect that in the post
Wrap it in code tags.
[code ] [/code ] (without the space).
ur codings are working excelent.
Thanks, bit more readable now