ScottPletcher (2/11/2013)
Marius.D (2/11/2013)
Scott:
or maybe you specified DESC on one of the existing index keys?!
I did not, but would that make a difference? I didn't think the missing indexes dmv has any kind of sort order information?
I was thinking maybe an existing index had one (or more) columns as DESC, which caused SQL to recommend that same index again only with ASC. But it seems as if SQL simply has a bug and recommends an index identical to one that already exists.
Scott, you are implying that the missing indexes dmv's (or somewhere else) there is sort order information about these missing indexes. Is that true? I can't see it..