-
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.
-
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
5 Reasons why you Shouldn’t Ignore Salesforce Google Ads Integration
Salesforce Google Ads Integration Marketers set aside a sizeable amount of their total marketing budgets to Google Ads. However, there have been huge challenges with…
WordPress and Salesforce Integration - What You Should Know
Organizations that want to improve the way they deliver digital assets to their audiences would benefit from using WordPress together with Salesforce. When you deliver…
4 favorite Salesforce Spring ’18 Release features
There has been a lot of buzz in the cyberspace about the much awaited Salesforce Spring '18 Release. Even though the Salesforce Spring '18 Release…
Popular Salesforce Videos
Data Access for Apex, Visualforce, and Lightning
Apex is a development platform for building software as a service (SaaS) applications on top of Salesforce.com's customer relationship management (CRM) functionality. Apex allows developers…
See how fast and easy you can make intuitive Salesforce solutions to your users with Cauzali.
Instead of coding or very complex flows use Cauzali. Place your Cauzali model everywhere in Salesforce including in the middle of a Flow. Price between…
Get Lookup Data From Salesforce Using Relationship Queries
Watch this video to learn how you can create a smart query that will make the lookup show only part of the data.