====== Indexing and Optimization ======


==== Creating Indexes ====

<code>
CREATE INDEX idx_email ON users(email);
</code>

Improves search performance on the email column.

==== Optimizing Queries ====


  * Use indexes on frequently searched columns.
  * Avoid using SELECT *; specify required columns.
  * Use EXPLAIN to analyze query performance:
<code>
EXPLAIN SELECT * FROM users WHERE email = 'john@example.com';
</code>
Normalize your database to reduce redundancy.