Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Index Types RE: Index Types

  • July 22, 2010 at 6:49 am

    #1196812

    I new I will get incorrect answer 🙂

    I based my answer on sys.indexes "type" column:

    Type of index:

    0 = Heap

    1 = Clustered

    2 = Nonclustered

    3 = XML

    4 = Spatial