MySQL 8.4 · Performance and maintenance
Create an index
Add an index to speed up lookups on a column.
CREATE INDEX idx_users_email ON users (email);
Official MySQL 8.4 documentation
More performance and maintenance commands
- See a query's plan
- Run a query and see real timings
- Refresh index statistics
- See running queries
- Check a server setting
- Count open connections
All performance and maintenance commands · MySQL 8.4 cheatsheet