Post reply

index question

  • August 29, 2007 at 6:44 pm

    #69338

    select * from sysindexes

     

    i see on a table has an index called _WA_Sys_QID_286302EC on QA. But i can't see that on EM

    is this some kind of corruption?

  • August 29, 2007 at 6:59 pm

    #730297

    Those are statistics, not indexes.

  • August 29, 2007 at 8:12 pm

    #730299

    any ideas how to restore the statistics? or transfer from one table to another?

  • August 29, 2007 at 10:27 pm

    #730314

    The statistical index you are seeing is usually the result of having

    "Auto create statistics" turned for the database. If SQL Server needs to know more information about a column (this occurs when you include the column in the WHERE clause but the column isn't in an index), it will create a record similar to what you are seeing in sysindexes.

    Have a look at the CREATE STATISTICS command. This will explicitly create the relevant statistics about the table/colums specified (hopefully before SQL Server needs that information)

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

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