Is there a stored procedure for computing stats (like Oracle dbms_stats packege)

Hi Team:

I am relatively new to sql server 2005. I have a need to calculate stats on tables (and indexes). Is there any dbms_stats like functionality in SQL server?

Can you please guide me?
Who is Participating?
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Scott PletcherSenior DBACommented:
That is:

-- run from within Query Analyzer (or a T-SQL job step)
EXEC sp_updatestats
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.