Index Rebuild (Job) vs CPU

  • Carl B. (5/3/2010)


    Hello Jeffrey,

    We are using the build-in Rebuild Index task. I don't see any way to enable or disable statistics recomputation in that task.

    Any way, lets say that we were using STATISTICS_NORECOMPUTE = ON, what would cause a defragmented index to be less "attractive" for the Optimizer after a rebuild compared to before the rebuild?

    Regards.

    Carl

    With that flag on - the statistics are not updated and that could cause the index to not be used.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • If i understand correctly, If your table has any non clustered index which might not be included in your REBUILD. Rebuild operation will only do "update statistics" of the concerned rebuilded index, not for other indexes. In this case, you need to run sp_updatestats separatly.

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

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