–普通索引(单列索引)
CREATE INDEX test_index ON test_table(user_name);
–唯一索引(单列索引)
CREATE UNIQUE INDEX id_index ON test_table(id);
–组合索引
CREATE INDEX id_name_index ON test_table(id, user_name);
–修改索引名
ALTER INDEX a_index RENAME TO b_index;
–删除索引
DROP INDEX test_index;