Update Statistics Task

The update statistics task updates information about the distribution of key values for one or more statistics groups (collections) in the specified table or indexed view. 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.

Step 1:

Drag and drop update statistics task and edit it

Step 2:

Give a new connection as update statistics task

Step 3:

Select database as AdventureWorks

Step 3:

Click on view T-SQL

Step 4:

Select update mode as all existing statistics

Step 5:

Execute a task