The iterative process of rewriting SQL queries or adjusting index strategies to reduce execution time. Starts with EXPLAIN analysis to identify full scans and inefficient joins, then applies targeted fixes.
