sp_updatestats vs UPDATE STATISTICS

[DBAWinnipeg]

Does anyone know what exactly sp_updatestats does?

It says it updates the stats for ALL user tables but I find that in running sp_updatestats performance does not increase as much as if I run UPDATE STATISTICS.

so what's I'm wondering is, is does sp_updatestats just do the stats it "thinks" it should do... or ALL stats without prejudice.



Thanks in advance!!!

Colin in da 'Peg

 

[vongrunt]

AFAIK sp_updatestats simply runs UPDATE STATISTICS [WITH RESAMPLE] over all user tables. Other options like WITH FULLSCAN and WITH SAMPLE <x> ROWS|PERCENT are not available that way.

To eliminate all doubts, you can see source code for this stored procedure in masterdb.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)