• 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.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP