快速參考建立一般索引與唯一索引的標準語法,含複合索引寫法。
CREATE INDEX idx_name ON table_name (column_name);
CREATE UNIQUE INDEX idx_name ON table_name (column_name);
CREATE INDEX idx_composite ON table_name (col1, col2);
-- 單欄
CREATE INDEX idx_lastname ON Persons (LastName);
-- 複合
CREATE INDEX idx_name ON Persons (LastName, FirstName);
-- 指定索引類型
CREATE INDEX idx_name ON Persons (LastName) USING BTREE;
-- 全文索引
CREATE FULLTEXT INDEX idx_content ON Articles (content);
-- MySQL
ALTER TABLE table_name DROP INDEX idx_name;
-- 標準 SQL
DROP INDEX idx_name ON table_name; -- 或 DROP INDEX idx_name (Oracle/PG)