July 9, 2008 at 11:51 am
Hi all,
I've read some posts that indicate that using UPDATE STATISTICS on large tables without the use of WITH FULLSCAN can lead to performance degredation.
My question is:
Will I end up hurting performance if I make use of DBREINDEX as this executes sp_UPDATESTATS?
Also is it bad to run any of the above on replicated DB's while in contineous merge replication?
Anyone care to share their thoughts?
July 9, 2008 at 12:31 pm
DBRindex updates the stats with full scan. What I always advise against is doing a sampled update stats (the default) after a reindex, because the update stats can leave the stats less accurate.
No idea on merge repl. I've never worked with it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply