function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
new_bienew_bie 

Indexed fields Purpose?

Hi 

 

what are the Indexed fields in salesforce.

 

Which sittuation we are using INDEXED fields.

 

Can you explain with a small example.

 

Regards.

Best Answer chosen by Admin (Salesforce Developers) 
Rahul SharmaRahul Sharma

Here is the link of salesforce documentation for Indexing :Working with Very Large SOQL Queries

In short, with use of indexed field in query filter, you could optimize the query retrieving time and fetch the results faster.

All Answers

Rahul SharmaRahul Sharma

Here is the link of salesforce documentation for Indexing :Working with Very Large SOQL Queries

In short, with use of indexed field in query filter, you could optimize the query retrieving time and fetch the results faster.

This was selected as the best answer
new_bienew_bie
Hi Rahul,

Thanks for valuable information.

Regards..
marcobmarcob

Hi,

 

the url you included in your post explains about indexing says:

 

  • The following fields are indexed by default: primary keys (Id, Name and Owner fields), foreign keys (lookup or master-detail relationship fields), audit dates (such as LastModifiedDate), and custom fields marked as External ID or Unique.

However, in my experience the lookup fields are NOT indexed by default. I also got info from Dreamforce '13 which confirms that. 

 

Any idea?

 

Regards,

Marco