-
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.
Popular Salesforce Blogs
How File Sync and Share Can Help You Stay Organized? | Salesforce Sales Cloud
Are you tired of wasting time searching for files on your computer? If you’re like most people, you probably have several folders spread out across…
An Introduction to Salesforce Service Cloud
In this era, customers expect service to be as instant and also as easy as their normal conversation. Service Cloud is an easy to use…
Smart Dynamic Forms for Salesforce
Do it yourself - Dynamic forms, conditional logic and realtime field population for salesforce without writing a single line of code. When working with online…
Popular Salesforce Videos
Prepare for Your Salesforce Pardot Implementation
If you're preparing for your Pardot implementation, you've come to the right place! Pardot implementation is a complex, multi-step process. In this video, we will…
Parent to Child SOQL vs Map | Salesforce Training in Apex
Watch this video to learn all about Parent to Child SOQL vs Map. Do let us know in the comment section if you have any…
How Admins Can Improve Salesforce Data Quality
Learn how to diagnose the accuracy of your data and build a plan to maintain and enhance its’ quality using Salesforce tools. Follow along to…
