AndrewM-375946
Right there with Babe
Points: 747
More actions
January 19, 2007 at 4:02 am
#176483
When using the dbreindex command, the statistics are automatically updated. But what sample rate does it use. I have found nothing concrete, The only sugesstion i have had is that it uses the previous sample rate. Is this true?
MohammedU
SSCoach
Points: 19644
January 19, 2007 at 1:21 pm
#684426
It uses full scan mean 100%...
you can with DBCC SHOW_STATISTICS command in your output check for ROWS and ROWS SAMPLED columns to get the info...
MohammedUMicrosoft SQL Server MVP
January 23, 2007 at 9:10 am
#684972
Thats a bit strange because a custom job that only rebuilds the STATS with FULL SCAN takes
3:30 hr to complete while a Dtabase maintenaince plan that uses DBCC REINDEX does the indexes and STATS in less than 1:30 hr
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply