Post reply

statistics question

  • May 2, 2009 at 11:32 am

    #137223

    when i issue "sp_helpstats categories" to see statistics - it says, this object does not have any statistics. but when i issue select * from sys.stats where object_id = 2137058649 --- categories object, it list two objects here.

    Also when i drill down using SSMS - DB - categories Table - statistics - i could see 2 statistics here and these are in sync with the sys.stats view results.

    my question is - why does sp_helpstats complain there's no statistics on this table where as the statistics do exist?

    anything i am interopating wrong? any assistance would be greatly apprecaited.

  • May 2, 2009 at 12:09 pm

    #987741

    Try this. The All parameter will include statistics that are also associated with an index.

    sp_helpstats 'categories','ALL'

    If you look at the @results parameter in books online, it should make a little more sense.

    http://msdn.microsoft.com/en-us/library/ms173416.aspx

  • May 2, 2009 at 3:28 pm

    #987754

    thanks for the help.

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

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