?
Solved

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

Posted on 2007-10-01
2
Medium Priority
?
453 Views
Last Modified: 2013-12-19
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?
0
Comment
Question by:raGadiraju
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1000 total points
ID: 19994082
0
 
LVL 70

Expert Comment

by:Scott Pletcher
ID: 19994331
That is:

-- run from within Query Analyzer (or a T-SQL job step)
EXEC sp_updatestats
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

750 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question