DROP STATS

Description

Delete statistics information for the specified table and columns. If no column names are specified, the statistics information for all columns will be deleted.

Syntax

DROP STATS <table_name> [ <column_names> ]

Where:

column_names
  :
  (<column_name>, [ <column_name>... ])

Required Parameters

<table_name>

The identifier (name) of the table.

Optional Parameters

<column_names>

List of column identifiers (names).

Access Control Requirements

Users executing this SQL command must have at least the following privileges:

Privilege	Object	Notes
DROP_PRIV	Table

Examples

• Delete statistics information for all columns in table1

  DROP STATS table1

• Delete statistics information for col1 and col2 in table1

  DROP STATS table1 (col1, col2)