Index Checker and Fragmentation - Duplicate INDEX name

  • dtran1127

    SSC Veteran

    Points: 201

    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

    SSC Eights!

    Points: 933

    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: 442116

    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply