da-zero (5/20/2010)
Why is the correct answer 4?I count 7 types of indexes:
clustered, non-clustered, unique, index with included columns, indexed views, full-text and xml.
See http://msdn.microsoft.com/en-us/library/ms175049(v=SQL.90).aspx.
Even in the explanation given I count more than 4.
Question about types of index structures... not index types. So snagging abit from the end off each line give us:
B-Tree structure
token-based functional index
internal table(aka nodes table)
B+-Tree