This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See DROP BLOOM FILTER INDEX.
DROP BLOOMFILTER INDEX ON [TABLE] table_name [FOR COLUMNS(columnName1, columnName2, ...)]
Drop a Bloom filter index.
The command fails if either the table name or one of the columns does not exist. All Bloom filter related metadata is removed from the specified columns.
When a table does not have any Bloom filters, the underlying index files are cleaned when the table is vacuumed.