W3Schools SQL | #50 SQL CREATE INDEX 구문

SQL CREATE INDEX Statement

SQL CREATE INDEX Statement

인덱스를 생성하기

CREATE INDEX index_name
ON table_name (column1, column2, ...);

CREATE INDEX Example

CREATE INDEX idx_lastname
ON Persons (LastName);

DROP INDEX Statement

DROP INDEX index_name ON table_name;