1

There is a Managed Package on which some of the custom fields are to be indexed so as to improve SOQL Query performance for one of the subscriber's org? Our initial connect with the Salesforce support rep was that they will not be able to edit Managed Package metadata which seemed a little surprising for me. Please can you let me know your thoughts.

  • 1
    According to this video: youtube.com/watch?v=jeysYua6ENs, all managed package code is stored only a single time for all orgs using it within a pod. I wonder if that also applies to their object metadata, and if so, I could see why they wouldn't be able to index it. – SFDC Neuf Feb 7 '17 at 21:54
3

Salesforce support can absolutely index managed fields. They did this for me via partner support on a number of occasions at past jobs, including indexing deterministic formulas and using two-column indexes.

There are not any special restrictions around index on managed fields that I am aware of, and if there are they are obscure enough to likely be irrelevant for most people.

| improve this answer | |
2

You can only index fields that are allowed normally, according to 000006007:

A Custom Index can't be created on these types of fields:

  • Multi-select Picklists.
  • Currency fields in a Multicurrency Organization.
  • Long text fields.
  • Binary fields (fields of type blob, file, or encrypted text.).

Note: New data types, typically complex ones, may be added to Salesforce and fields of these types may not allow custom indexing.

Perhaps Support was trying to communicate that a particular field could not be indexed because of its data type? If so, you'll probably need to eventually refactor your code and objects to use a data type that can be indexed.

| improve this answer | |
  • I have to admit I didn't speak to support directly but one of my colleague passed on this information. I was bit surprised on support not being able to help and hence, posted this question to get broad reviews. Thanks a lot for your time! PS: I am a big fan of your answers on this site :)... please keep up the great work – ArreyYaar Feb 9 '17 at 15:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.