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
Номер статьи базы знаний

000394552

 
Загрузка
Salesforce Help | Article