Learn how to prevent expensive full table scans. Understand how functions in WHERE clauses, wildcard LIKE searches, and OR conditions kill performance.