update all statistics

Description

Updates all statistics information for a given table.

Syntax

update all statistics table_name

Parameters

table_name

is the name of the table for which statistics are being updated.

Examples

Example 1

Updates index and partition statistics for the salesdetail table:

update all statistics salesdetail

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

update all statistics permission defaults to the table owner and is not transferrable.

See also

Commandsupdate statistics, update partition statistics