Selective queries in SOQL are optimized for performance. Query B is selective because it filters out empty names, which are likely to be less in number. Query C is selective if the list of names is small, and 'Customer_Number_c' is indexed or can be used as an external ID field. References: Working with Very Large SOQL Queries
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit