Techrecruit
SSC Veteran
Points: 276
More actions
July 9, 2007 at 12:18 pm
#117252
Does it really matter or should I schedule the indexes in my SQL databases to be rebuilt before or after the statistics on my tables are updated?
Christina Le-215319
Grasshopper
Points: 18
July 9, 2007 at 1:56 pm
#718096
Hello,
DBREINDEX statement automatically updates statistics so you don't have to run the it
separately.
noeld
SSC Guru
Points: 96590
July 9, 2007 at 4:20 pm
#718130
On the other hand DBCC INDEXDEFRAG does requires to update the statistics afterwards!
* Noel
July 19, 2007 at 1:16 pm
#720892
Much oblige
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply