Is there any advantage of using operator "IN" instead of "NOT IN" in SOQL? Are there any performance benefits of it?
I have a use case where I have to filter the records based on a certain column, say Region, which has many distinct values. NOT IN is preferable since only a fraction of those distinct values will be used for filteration.
e.g. let there be 10 distinct values in Region ... 1. NJ 2. NY 3. .. ..... 10. CL
the NOT IN will only contain, say NJ and NY