WayneS (7/22/2010)

---

For everyone that thinks that the BOL reference in the QotD is wrong and that there are just 5 types of indexes: I created a connect item at https://connect.microsoft.com/SQLServer/feedback/details/577460/documentation-types-of-indexes to fix the documentation. Please go vote on it.

cengland0 (7/22/2010)

---

That's wonderful. So if it gets approved and the BOL is updated, do I get my point that I lost for this QOTD?

magasvs (7/24/2010)

---

It would be confusing to get this question on interview, is it? I wouldn't know what is the right answer, probably would give two answers :)

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