Index Checker and Fragmentation - Duplicate INDEX name

• dtran1127

  Old Hand

  Points: 343

  More actions

  August 28, 2018 at 10:44 am

  #362221

  Hello:

  How is it possible to get the SAME index name for the SAME table but the Index ID is different?

  

  I know that the picture represents a FRAGMENTED index which then I will have to "REBUILD" correct?

  What are your suggestions? I would love to hear some of them as I am starting to build my skills in Maintenance.

  Index Maintenance is my first step and I want to learn all that I can. Please provide any information as well too! Thank you

• mig28mx

  Ten Centuries

  Points: 1090

  More actions

  October 23, 2018 at 12:48 pm

  #2010840

  Hi,
  Yes, with that percentage, your choice is to REBUILD that index.
  By the other hand, No. You can't have two indexes with the same name.
  I suggest to check the Ola Hallengren scripts for this tool. Of course you wil find a lot of scripts in the internet, but I believe this is the best tool:
  https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

  Hope this helps.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  October 23, 2018 at 1:39 pm

  #2010845

  dtran1127 - Tuesday, August 28, 2018 10:44 AM

  Hello:

  How is it possible to get the SAME index name for the SAME table but the Index ID is different?

  

  I know that the picture represents a FRAGMENTED index which then I will have to "REBUILD" correct?

  What are your suggestions? I would love to hear some of them as I am starting to build my skills in Maintenance.

  Index Maintenance is my first step and I want to learn all that I can. Please provide any information as well too! Thank you

  Could you post the query that generated the picture?  Something doesn't look right.