External ID

If you want blazing-fast SOQL, your filters have to be selective. In practice, that means your WHERE clause narrows things enough for Salesforce to rely on an index. Use the Query Plan tool to see what the optimizer intends to do and shape your filters to hit standard, custom, or...