Most SOQL performance problems don't show up until production. Your query works fine in sandbox with 2,000 records, then takes 30 seconds against 500,000. Here's what I've learned about writing queries that actually scale.
Salesforce Admin & Config
Flow Builder, data modeling, SOQL, approval processes, custom metadata, and platform cache.
