Post reply

HEAP index ????

  • March 21, 2013 at 11:25 am

    #291404

    CAn you please help me figure this one out??

    In MS, I am looking at the table and see no indexes there...

    However, running this select and get the following result:

    SELECT * FROM SYS.INDEXES I WHERE I.object_id = object_id('TABLENAME')

    object_id

    927342368

    name

    NULL

    index_id

    0

    type

    0

    type_desc

    HEAP

    is_unique

    0

    data_space_id

    1

    ignore_dup_key

    0

    is_primary_key

    0

    is_unique_constraint

    0

  • March 21, 2013 at 11:31 am

    #1599503

    In the sys.indexes table an index_id of 0 indicates that the table is a heap, no clustered index. An index_id of 1 indicates that there is a clustered index. These two values are mutually exclusive. A table is either a heap or has a clustered index (i.e. the table).

  • March 21, 2013 at 12:07 pm

    #1599516

    thank you

    got it

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply