In database systems, writing a correct SQL query is important — but writing an efficient one is even more critical. When a query is executed, the database does not follow it exactly as written.

Have you ever stared at a slow SQL query, wondering how the database even begins to make sense of it? I’ve seen that moment countless times, at Microsoft, at Meta, and nearly every engineering team ...