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

Dan Guzman - Not the MVP (7/22/2010)

---

All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'