Allow Date, DateTime and Picklist fields to be indexed - Ideas - Salesforce Trailblazer Community

All Ideas

Idea Details

Post an Idea
810  Points
Open
Idea has been posted. Give it an upvote or downvote.

Allow Date, DateTime and Picklist fields to be indexed

Data Services

Right now, you can "index" a field by marking it as an External Id when declaring the field. However, this only works for Text and Numeric fields.

This functionality should be exposed to Date, DateTime and Picklist* fields as well.

Right now, it requires a Case to be opened to get the org analyzed, provide repro cases, go through extensive "business justification", wait several hours between each run of the slow query (since you have to wait for the query cache to expire) before Support will finally agree to have the field indexed.

As an ISV, this is hand to hand combat since each org must be done individually. By packaging the field as an External Id, we can get all the love and happiness without the hours and hours of human suffering for each org.

* We understand that the cardinality of Picklist may be low and therefore not a good candidate for an index. But it's often the case that there are a few highly selective picklist values. So if you allow it for Text fields, why not allow it for Picklist?

Merge Idea · Flag

  • Upvotes
  • Downvotes

Ideas

Apps

from AppExchange

Questions

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



 

 

Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


 

Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.