You need to sign in to do that
Don't have an account?
Raymond van Akkeren
are all fields of type Phone automatically indexed?
I just reviewed a query on Account that to my suprise is very selective (Cardinality=1,Leading Operation Type=Other, cost=0.000000, sObject Cardinality=8,700,000).
SELECT Id, Account.BPID__C, Account.Name FROM Account WHERE phone = '999' OR PhoneStandard__c = '999' OR MobilePhone__c = '999' OR PhoneVisit__c = '999'
When I verify the fields, it seems that only Phone has been indexed. Does anybody understand how this is possible? I can't find any documentation on whether fields of type Phone are always indexed.
SELECT Id, Account.BPID__C, Account.Name FROM Account WHERE phone = '999' OR PhoneStandard__c = '999' OR MobilePhone__c = '999' OR PhoneVisit__c = '999'
When I verify the fields, it seems that only Phone has been indexed. Does anybody understand how this is possible? I can't find any documentation on whether fields of type Phone are always indexed.