Maximum Number of Custom Indexes Per Salesforce Object

How Custom Indexes Are Created in Salesforce:

There are three ways custom indexes are created in Salesforce:

• Option A — External or Unique Field: Marking a field as "External" or "Unique" will create a custom index on that field. Note that this method has its own separate limit, defaulted at 7.
• Option B — Automatic Indexing: Some indexes are created automatically when Salesforce systems determine a field will benefit from one.
• Option C — Salesforce Support: Custom indexes can be created by Salesforce Support as part of a performance case (for example, SOQL queries or Analytic Reports timing out).

Requesting a Limit Increase or Performance Assistance:

If you've reviewed all relevant documentation and still need assistance with custom indexes or a performance issue, please have a System Administrator create a limit increase request with Support.

When submitting your request, please be specific and include:

• Whether the performance issue exists within a SOQL query, a report, or another area
• Links to the affected queries or reports
• Login access for the Support analyst so the case can be routed to the appropriate teamImportant Notes:
  • Custom indexes are not the only tool that will be used in a performance case — Salesforce Support will evaluate the full picture.
  • Custom indexes, when used improperly, can actually slow query results. Always consult with Salesforce Support before requesting an index on a specific field.