-- 假设我们有一个员工表 employeesCREATETABLE employees (
id INTAUTO_INCREMENT,
name VARCHAR(100),
department_id INT,PRIMARYKEY(id));-- 为department_id字段创建索引CREATEINDEX idx_department ON employees(department_id);-- 使用索引进行查询SELECT*FROM employees WHERE department_id =5;