update partition statistics

Description

Updates information about the number of pages in each partition for a partitioned table.

Syntax

update partition statistics table_name [partition_number]

Parameters

table_name

is the name of a partitioned table.

partition_number

is the number of the partition for which you are updating information. If you do not specify a partition number, update partition statistics updates the number of data pages in all partitions in the specified table.

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

update partition statistics permission defaults to the table owner and is not transferable.

See also

Commands alter table, update all statistics

Functions ptn_data_pgs

System procedures sp_helpartition