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 ?