Index

Show

SHOW INDEX FROM <table>;               -- 존재하는 index 보기

SHOW TABLE STATUS LIKE <table string>; -- index 상태 보기

Create

CREATE <UNIQUE> INDEX <index>
    ON <table>(<column>) <ASC | DESC>; -- index create

ANALYZE TABLE <table>;                 -- index apply

Drop

DROP INDEX <index> ON <table>;