Duplicate Indices on Columns

• dingle1975

  SSC-Addicted

  Points: 486

  More actions

  May 18, 2006 at 4:22 am

  #168307

  Hi all,

  Was wondering if someone could tell me how to easily identify if a column within a table has duplicate indices on it?  I have inherited a DB which has many, many tables and have tasked with this as part of a performance tuning exercise.  Any help/advice would be great.  I should also state that I'm new to the DBA world! ;o)

  Thanks,

  Dave.

• Pam Brisjar

  SSChampion

  Points: 12094

  More actions

  May 18, 2006 at 7:48 am

  #638714

  Have a look here:

  http://www.sql-server-performance.com/ma_finding_duplicate_indexes.asp

• dingle1975

  SSC-Addicted

  Points: 486

  More actions

  May 18, 2006 at 8:06 am

  #638731

  Hi Pam,

   

• dingle1975

  SSC-Addicted

  Points: 486

  More actions

  May 18, 2006 at 8:07 am

  #638732

  'Thanks' was the next line of that message!