DROP AGGREGATING INDEX

Introduced or updated: v1.2.151

ENTERPRISE EDITION FEATURE

AGGREGATING INDEX is an Enterprise Edition feature. Contact Databend Support for a license.

Deletes an existing aggregating index. Please note that deleting an aggregating index does NOT remove the associated storage blocks. To delete the blocks as well, use the VACUUM TABLE command. To disable the aggregating indexing feature, set 'enable_aggregating_index_scan' to 0.

Syntax

DROP AGGREGATING INDEX <index_name>

Examples

This example deleted an aggregating index named my_agg_index:

DROP AGGREGATING INDEX my_agg_index;