michael.kaufmann (7/22/2010)
Wayne,first of all thank you for compiling a QotD.
However, I do not quite agree with the solution.
'Unique' is just taking the definition of a clusterd or non-clustered index a step further.
'with included columns' and 'filtered' again are non-clustered indexes (with advanced features).
So I don't see them as individual types, but sub-types at best.
Hence it comes down to 5 types (why I got it wrong):
- clustered
- non-clustered
- full-text
- spatial
- XML
I assume, though, that this is another wording issue ;-); nevertheless an excellent lesson having to recap what index types there are.
Thanks,
Michael
And XML index may be
- Primary
- Secondary
And secondary XML index can be
- for Path
- for Value
- for Property
As for me the question is not formalized properly