• It's possible they are hypothetical indexes, a remnant of database tuning advisor.

    What does the following return?

    SELECT

    name,

    is_hypothetical

    FROM

    sys.indexes

    WHERE

    OBJECT_NAME(object_id) = 'ABCTable'

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]