I am trying to evaluate some of our SOQL queries using query plan tool in Developer Console. Query is on custom object and we don't have any custom index on any of the custom field of this object.
when I run a query plan for one of the query, it is showing 2 plans. One is full table scan while other is having Index on custom field Status__c. But this field is not indexed.
Any idea why tool is showing index plan on a field which doesn't have index ?
I looked at FAQ, https://help.salesforce.com/apex/HTViewSolution?id=000199003&language=en_US and it is clearly mentioned that tool will not show fields that are candidate for indexing.
any idea what is going in here ?