Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    London
    Posts
    169

    Unanswered: Choosing the right index

    Hi,

    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:

    Code:
    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
    Which is the best candidate for a clustered index and how would I know?

    What else does the output tell me?
    Last edited by SQLSlammer; 06-23-09 at 08:34.

  2. #2
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    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

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Wrap it in code tags.
    [code ] [/code ] (without the space).
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    Thanks, bit more readable now

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •