mysql Index 추가 삭제

INDEX 조회

SHOW INDEX FROM table_name

 

INDEX 추가

ALTER TABLE table_name ADD INDEX idx_test ( column_name );

 

INDEX 삭제

ALTER TABLE table_name DROP INDEX idx_test;

 

INDEX 생성

CREATE INDEX idx_add ON table_name (column_name);

 

DROP문으로 인덱스 삭제

DROP INDEX idx_add ON table_name

 

UNIQUE 인덱스

CREATE UNIQUE INDEX UQ_idx_1 ON table_name (column_name);