FirebirdSQL logo
 TABLEVIEW 

DROP INDEX Example

Dropping the IDX_UPDATER index
DROP INDEX IDX_UPDATER;
See also

[fblangref50-ddl-idx-create], [fblangref50-ddl-idx-altridx]

SET STATISTICS

Recalculates the selectivity of an index

Available in

DSQL, ESQL

Syntax
SET STATISTICS INDEX indexname
Table 1. SET STATISTICS Statement Parameter
Parameter Description

indexname

Index name

The SET STATISTICS statement recalculates the selectivity of the specified index.