Enhanced Index Creation and Reindexing via ESS Job

The Enhanced Index Creation and Reindexing via ESS Job capability feature allows users to automatically create or repair database indexes for tables with a large volume of data using a background scheduled job, ensuring indexes are built smoothly even when manual attempts may fail due to data volume. It streamlines field indexing operations, reduces user errors, and minimizes application downtime by managing the indexing process asynchronously in the background. 

This feature significantly reduces downtime and errors associated with indexing for tables with a large volume of data, leading to improved data integrity and application availability. By automating the index creation process using background jobs, businesses can ensure consistent system performance, faster data access, and an overall smoother user experience—especially when handling high data volumes. This also lowers operational burden for administrators by eliminating manual interventions and repeated index creation failures.

Steps to Enable and Configure

You don't need to do anything to enable this feature.

Tips And Considerations

To check the index job status, you can follow these steps:

  • After marking the field as indexed and clicking  "Save", the system triggers an scheduled job to create the index. 
  • Navigate to the scheduled process section in your application. Here, you can search for the submission notes related to the job named "Create Index" to find the status of the job.
  • If the job fails, the reason is logged in the scheduled process UI. The index checkbox will not remain editable. For failures due to temporary resource issues, you can publish the sandbox, and the index creation will be handled by the 'Recreate Index' process.

Additional Notes: 

  • Always verify that the correct field and table names are selected before triggering the index creation job, especially in custom objects.
  • Monitor the status of the scheduled job through the scheduled processes UI, and review the process log for any errors or issues.
  • Note that custom index creation is limited to a maximum threshold (typically 10 custom indexes across all objects), so plan accordingly for new custom fields.
  • Be aware that the job may rely on current metadata and sandbox changes—ensure configurations are published if working in a sandbox environment.
  • For best performance, schedule large index jobs during off-peak hours or maintenance windows when possible.
  • If errors persists (e.g., due to privilege or data model limitations), consult the generated error message and system logs, or seek administrative help as needed.

Access Requirements

  • Custom Objects Administration 
  • Customer Relationship Management Application Administrator 
  • Application Implementation Consultant