Reference and syntax for the DROP INDEX command.
DROP AGGREGATING INDEX [IF EXISTS] <index_name>
<index_name>