Post reply

Find Duplicate Indexes

  • October 7, 2007 at 2:17 pm

    #95405

    Comments posted to this topic are about the item Find Duplicate Indexes


    "Keep Your Stick On the Ice" ..Red Green

  • June 19, 2008 at 9:52 am

    #831210

    Awesome query! Solved my headache today

  • January 8, 2014 at 3:13 pm

    #1678610

    Ouch! This doesn't take into account the sort order of the keys! It will identify these two indexes as duplicate:

    CREATE NONCLUSTERED INDEX [idx01] ON [dbo].

    (

    [d5comp] ASC,

    [d5jbns] ASC

    )

    CREATE NONCLUSTERED INDEX [idx02] ON [dbo].

    (

    [d5comp] ASC,

    [d5jbns] DESC

    )

    Pretty sure that's not correct.

  • July 11, 2017 at 1:56 pm

    #1950430

    If people are looking for a GUI for this. Aireforge Studio will check for duplicate, overlapping, missing and redundant indexes from the Advise module. You can download the free trial from http://www.aireforge.com.

    Solving data & infrastructure issues via xTEN[/url] and our application, Aireforge[/url].

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

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