Post reply

error on sp_createstats

  • November 19, 2002 at 2:28 am

    #441696

    Hi, did you try

    EXEC sp_createstats 'indexonly'

    This create statistics only for columns with an index.

  • November 19, 2002 at 8:01 am

    #441718

    Is it a good idea to create statistics on columns that are not indexed? Is there a performance benefit to this, or is it not worth the effort?

    If it is recommended, I would like to keep ALL statistics updated, not just the ones on the columns with indexes.

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

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