Post reply

SQL 2008 sysindexes indid

  • August 31, 2011 at 2:05 am

    #247217

    Hey Guys

    Please help

    What does the columns 'indid' mean in the sysindexes table?

    Which index type belongs to which number?

    Thanks

  • August 31, 2011 at 2:10 am

    #1375342

    Don't use sysindexes for anything in SQL 2008. It's deprecated,will be removed in a future version.

    Use sys.indexes. It's better documented and the columns are better named.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 31, 2011 at 2:24 am

    #1375344

    Thanks

    So, i'm assuming that the index_id columns is the equivalent?

    What do the numbers in that column indicate?

    Is 0= Heap

    1= Clustered Index

    and anything > 1 = Non Clustered Index?

    Thanks

  • August 31, 2011 at 2:27 am

    #1375345

    Gail

    I'm using the sysindexes to obtain the date that stats were last updated.

    I make use of the rows modified and the rowcount

  • August 31, 2011 at 9:16 am

    #1375547

    sysindexes is still deprecated, doesn't matter how you use it. Row count you can get in sys.partitions. Stats update date from Stats_Date function. There's no replacement for rowmodcrt, but that column's calculated and not guaranteed accurate on 2008 anyway,

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 31, 2011 at 9:28 am

    #1375553

    derekr 43208 (8/31/2011)

    Thanks

    So, i'm assuming that the index_id columns is the equivalent?

    What do the numbers in that column indicate?

    Did you look in the documentation I mentioned? http://msdn.microsoft.com/en-us/library/ms173760%28v=SQL.100%29.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 1, 2011 at 12:33 am

    #1375797

    Thanks Gail!

Viewing 7 posts - 1 through 6 (of 6 total)

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