DROP INDEX Example
Dropping the
IDX_UPDATER
indexDROP INDEX IDX_UPDATER;
IDX_UPDATER
indexDROP INDEX IDX_UPDATER;
SET STATISTICS
Recalculates the selectivity of an index
DSQL, ESQL
SET STATISTICS INDEX indexname
Parameter | Description |
---|---|
indexname |
Index name |
The SET STATISTICS
statement recalculates the selectivity of the specified index.