[MariaDB] INDEX 생성

Syntax

CREATE INDEX 인덱스명 ON 테이블(...컬럼)

CREATE [OR REPLACE] [UNIQUE|FULLTEXT|SPATIAL] INDEX 
  [IF NOT EXISTS] index_name
    [index_type]
    ON tbl_name (index_col_name,...)
    [WAIT n | NOWAIT]
    [index_option]
    [algorithm_option | lock_option] ...

index_col_name:
    col_name [(length)] [ASC | DESC]

index_type:
    USING {BTREE | HASH | RTREE}

index_option:
    KEY_BLOCK_SIZE [=] value
  | index_type
  | WITH PARSER parser_name
  | COMMENT 'string'

algorithm_option:
    ALGORITHM [=] {DEFAULT|INPLACE|COPY|NOCOPY|INSTANT}

lock_option:
    LOCK [=] {DEFAULT|NONE|SHARED|EXCLUSIVE}

 

인덱스 조회

SHOW INDEX FROM table_name

 

인덱스 생성

CREATE INDEX 인덱스명 ON 테이블명(컬럼)

 

인덱스 삭제

DROP INDEX 인덱스명 ON 테이블명

 

 

참고자료
https://mariadb.com/kb/en/create-index/