SYSCS_UTIL.DROP_SCHEMA_STATISTICS

The SYSCS_UTIL.DROP_SCHEMA_STATISTICS  system procedure drops statistics for a specific schema in your database.

This procedure drops statistics for every table in the schema. It also drops statistics for the index associated with every table in the schema. For example, if you have :

  • a schema named mySchema
  • mySchema contains two tables: myTable1 and myTable2
  • myTable1 has two indices: myTable1Index1 and myTable1Index2

Then SYSCS_UTIL.DROP_SCHEMA_STATISTICS will drop statistics for myTable1, myTable2, myTable1Index1, and myTable1Index2.

Syntax

SYSCS_UTIL.DROP_SCHEMA_STATISTICS( VARCHAR(128) schema );

schemaName

Specifies the schema for which you want to drop statistics. Passing a null or non-existent schema name generates an error.

Results

This procedure does not produce a result.

SQL Examples

splice> CALL SYSCS_UTIL.DROP_SCHEMA_STATISTICS('MYSCHEMA');
Statement executed.

See Also