-
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
Plauti Offers Flow Action Capabilities on Duplicate Check for Salesforce AppExchange
Plauti today announced it has updated Duplicate Check on Salesforce AppExchange, providing customers new ways to integrate the checking and merging of duplicate records into their…
Is the Salesforce Advanced-Administrator Exam Worth It? Here’s What You Need to Know
In today's fast-paced digital environment, staying ahead in your career often means enhancing your skills and knowledge. For those in the Salesforce ecosystem, advancing from…
Setting SSO between Salesforce and Okta’s Custom Application using SAML 2.0 protocol
1. SSO(Single Sign On between Okta as Identity Provider and Salesforce as Service Provider) Steps to setup SSO between Salesforce and Okta:- Log in to…
Popular Salesforce Videos
Custom Types in Lightning-datatable | Interchange | Salesforce Tutorial
First episode of our new Interchange series, in which we will deep dive in how to define custom types for a lightning-datatable component. Concretely, we’ll…
Salesforce Sales Cloud Basics
This short video shows how easy to create & manage leads and to convert it to opportunity, contacts & accounts using Salesforce Sales Cloud. Please…
How To Assign Leads in Salesforce | Overview of 3 Main Lead Routing Solutions
Salesforce offers several options on how to automatically assign incoming leads to a suitable sales manager. But what to choose: out-of-the-box features, external AppExchange app,…
