← 返回教程列表
🐬 MySQL 教程
索引与优化
CREATE INDEX idx_name ON users(name);
EXPLAIN SELECT * FROM users WHERE name = "张三";
ALTER TABLE users ADD INDEX idx_age (age);CREATE INDEX idx_name ON users(name);
EXPLAIN SELECT * FROM users WHERE name = "张三";
ALTER TABLE users ADD INDEX idx_age (age);