Drop an index on the specified table.
DROP INDEX [IF EXISTS] indexName
indexName- the name of the index to drop.
IF EXISTS- do not throw an error if an index with the specified name does not exist. The database checks indexes' names only not considering columns types or count.
DROP INDEX command removes a previously created index.
DDL commands targeting the same table are blocked until the
DROP INDEX is in progress. DML commands execution is not affected and can be performed in parallel.
Schema changes applied by this command are persisted on disk if Ignite persistence is enabled. Thus, the changes can survive full cluster restarts.
Drop an index:
DROP INDEX idx_person_name;
Updated less than a minute ago