Hi,

What is the different between the DBCC updateusage('database_name')
and sp_updatestat ?

First, I run DBCC updateusage('db_name') on my db and some of
my SP really speed up.

However, when I run sp_updatestat, my SP just slow down.

So, I read from some articles that after dbcc indexdefrag is done,
we have to manually update the statistic.

So, why is sp_updatstat slowing down my SP.

Anyone got any ideal why ?