Update Statistics Task

This task will update the statistics for one of many tables in one or many databases. By using the Update Statistics task, a package can update statistics for a single database or multiple databases. If the task updates only the statistics in a single database, you can choose the views or the tables whose statistics the task updates. You can configure the update to update all statistics, column statistics only, or index statistics only.

This task encapsulates an UPDATE STATISTICS statement, including the following arguments and clauses:

Ø  The table_name or view_name argument.

Ø  If the update applies to all statistics, the WITH ALL clause is implied.

Ø  If the update applies only to columns, the WITH COLUMN clause is included.

Ø  If the update applies only to indexes, the WITH INDEX clause is included.

Step by step update statistics task

Take Update statistics task

Double click on update statistics task

Create new connection. Write the connection name and server name and select the windows authentication.

Click ok.

Select the database

Click OK.

Select the Object Type it may be

Ø  Table

Ø  View

Ø  Tables and views

Select update type

Select scan type

If you want to see the T-SQL click on view T-SQL button

Click ok.

Now execute the package.

It is executed successfully.