EMS logo

Products Navigation

SQL Backup for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Backup for SQL Server

On-line Documentation

Update Statistics


Update Statistics step allows you to perform the update statistics operation in your database (the UPDATE STATISTICS statement is issued). This operation is used to updates the statistics for the specified tables and views.

 

To launch the updating operation immediately select Quick_Maintenance_Actions Quick Maintenance Action | UpdateStatistics Update Statistics step popup menu item in the Servers tab.

 

To perform scheduled update of statistics on regular basis you need to include this task into Policy:

1. At Step 2 of the Create Policy wizard click Create new step button and select Update Statistics step type.

2. Also, you can create a new Step Template for further use selecting Update Statistics step at the Templates tab.

 

Steps of the Update Statistics wizard:

Naming step

Selecting objects

Setting options

Performing operation

 

 


See also:

Backup database

Execute SQL Server Agent job

Execute T-SQL statement

History Cleanup

Database Integrity Check

Shrink Database

Reorganize Indices

Update Statistics

Database Parameters Logger

Maintenance Cleanup

Transaction Log Shipping

Database Shipping

Bulk Restore