tommyh (5/21/2010)
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
Aaaaaaah. That explains 😀
Why do I answer those questions so early in the morning?
But, to nitpick a bit, the explanation isn't very clear. I have read it multiple times and it's hard (for me) to find the 4 distinct types of index structures.
Or maybe it is just friday...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP