Find Duplicate Indexes

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


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

  • Awesome query! Solved my headache today

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

  • 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