-- Create simple index
CREATE INDEX index_name ON table_name(column_name1 [, column_name2, ...])
-- Create unique index
CREATE UNIQUE INDEX index_name ON table_name(column_name1 [, column_name2, ...]
-- Drop index
DROP INDEX index_name ON tbl_name
[algorithm_option | lock_option] ....