-- Create index CREATE INDEX idx_customer_email ON customers (email); -- Composite index CREATE INDEX idx_order_date_status ON orders (order_date, status); -- Unique index CREATE UNIQUE INDEX idx_username ON users (username); -- Show indexes SHOW INDEX FROM customers;