During my work I found this query on a table with around 181k records and dozen of fields. Putting the query on the query planner I found a strange result as you can see:
The query is as follows:
Select C****__c,Field_B from List_of_values__c where R**** =: var1 and C****__c =: var2 and Attrib_36__c = true;
Both R**** and C****__c have index.
The funny things is that if we remove either one of these the cost is good and as you can see this is the result:
Why does the
Other cost pop up?