問題文
A telecom support org holds five million case records. A nightly report filters on one custom field, and that filter matches roughly six hundred thousand rows. The team wants to request a custom index on the field and expects the report to become selective. What should the architect tell the team?
選択肢
- The index would not be used at that match count, because a custom index applies only when the filter matches under ten percent of the first million rows and under five percent of the rest.
- The index will be used as soon as it is created, since a custom index is always preferred to a standard index and the query optimizer falls back to a standard index only when no custom index exists on any field named in the filter.
- The index will be used, because six hundred thousand rows is well under the thirty percent that the platform allows for the first million records.
- No index can help a report of this size; only a skinny table can, so the request has to be raised with Salesforce Support instead.