Explain Development Tutorials, Guides & Insights

CREATE INDEX idx_name ON users(first_name, last_name);

To view existing indexes on a table, use the SHOW INDEX command:

The output provides details like:

• Select Type: Type of query (simple, primary, subquery, etc.).
• Table: The table accessed by the query.
• Type: Type of access (e.g., index, ALL, ref, const).
• Possible Keys: Indexes considered by the optimizer.
• Key: Index used for the query.
• Rows: Estimated number of rows examined.
• Extra: Additional information, such as whether a temporary table or file sort is used.

SELECT name, department FROM employees;

Use WHERE to reduce result size early: