Post reply

Index Checker and Fragmentation - Duplicate INDEX name

  • 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

  • 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.

  • 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.

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

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