UPDATING COLUMN STATS WITH FULLSCAN

  • 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

  • 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