Loading

Custom Index created by an Automated process in salesforce

게시 일자: Oct 28, 2024
상세 설명
Sometimes we notice that a few of the custom fields were indexed  Looking  at the  field details, it was determined that the fields were indexed automatically by salesforce. Below are few questions surrounding this process which will help to understand this process.

Specific Questions:
  1. What value do these new indexes bring to performance?
  2. Based on what criteria does the process pick these fields ?
  3. If we remove the indexes on these fields, will the automated process try to add them back?
솔루션
Specific Questions:
  1. What value do these new indexes bring to performance?
These indexes were built in order to tune queries that were observed to be both slow and selective by our automated custom index recommender process.
  1. Based on what criteria does the process pick these fields ?
The process uses a formula to estimate the amount of query processing time in a one week period that could be saved if a field were indexed (the formula is based on the elapsed time of queries observed times an estimated fraction of that time that could have been saved with a custom index, based on the selectivity of the filters); it indexes the highest value fields that it finds based on this formula, provided that the estimated time saved exceeds a minimum threshold.
  1. If we remove the indexes on these fields, will the automated process try to add them back?
If the indexes are removed, they will be marked as removed in our custom index recommender table, and the process will not add them back

Salesforce also keep statistics on the usage of auto-created custom indexes once they're created
Knowledge 기사 번호

000394552

 
로드 중
Salesforce Help | Article