Help Center/ Data Warehouse Service/ SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ Performance and Execution Plans/ DROP STATISTICS
Updated on 2026-05-29 GMT+08:00
View PDF

DROP STATISTICS

Function

Deletes an extended statistics object. This syntax is supported only by clusters of version 8.2.1.200 or later (not supported by clusters of version 8.3.0).

Precautions

None

Syntax

1
 
DROP STATISTICS [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

Parameter Description

Table 1 DROP STATISTICS parameters

Parameter

Description

Value Range

IF EXISTS

Sends a notification rather than reporting an error if the specified extended statistics object does not exist.

-

name

Indicates the name of the extended statistics object to be deleted.

An existing extended statistics object name.

CASCADE | RESTRICT

This parameter does not take effect. No objects depend on extended statistics objects.

-

Examples

Deletes an extended statistics object. 
DROP STATISTICS s1_t1_row;

Helpful Links

CREATE STATISTICS

Parent Topic: Performance and Execution Plans