Post reply

UPDATING COLUMN STATS WITH FULLSCAN

  • January 10, 2014 at 4:54 am

    #302623

    Hi

    I am testing updating statistics using the "WITH FULLSCAN" option.

    Updating one set of INDEX stats takes a few minutes, but updating one set of COLUMN stats on the same table can take several hours.

    Can anybody shed some light on this? Is this what you would expect?

    Thanks in advance

  • January 13, 2014 at 5:19 am

    #1679539

    Green Armchair (1/10/2014)

    Hi

    I am testing updating statistics using the "WITH FULLSCAN" option.

    Updating one set of INDEX stats takes a few minutes, but updating one set of COLUMN stats on the same table can take several hours.

    Can anybody shed some light on this? Is this what you would expect?

    Thanks in advance

    What are the data types involved in the index stat and the column stat? Is the index filtered? Can you supply DDL for the table definition and the index definition.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

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

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