-
When Salesforce will use Standard Indexed fields?
When Salesforce will use Standard Indexed fields?
-
2 Replies
-
Salesforce maintains statistics table which stores information about records present in Organization. If records going to be searched is less than or equal to 30% of total records or up to 1 million records then only it makes sense to use standard Indexed fields to narrow result else total records going to be returned is more than 30% already so Salesforce will not use any indexing.
- [adinserter block='9']
-
The standard Salesforce indexed fields are:
Lead: Company, Email, Lead Owner, Name.
Contact: Account Name, Contact Owner, Email, Name, Reports To.
Account: Account Name, Account Owner, Account Record Type, Parent Account,
On top of these, system time fields (last modified, created date etc) and any lookup fields are also indexed.
Log In to reply.
