Questions tagged [indexing]
The indexing tag has no usage guidance.
4
questions
11
votes
2
answers
870
views
SOQL query selectivity changes with number of IN clause records
I have a custom object with a Master-Detail relationship to Opportunity. The relationship field to the parent Opportunity is automatically indexed.
There are 200,000 plus of these custom objects in ...
- 100k
5
votes
2
answers
564
views
Bulk data load make the global search unusable
We are migrating data from saleforce org A to org B. While migrating we are processing data out of salesforce and its out of scope of this question. When we load data into target org it breaks the ...
- 9,060
4
votes
2
answers
851
views
How do custom indexes impact performance negatively?
I am trying to understand the negative tradeoffs in creating more custom indexes on an sObject. Yes, they are helpful with query selectivity which speeds up reading data, but at what price. ...
- 10.4k
2
votes
2
answers
6k
views
Can a formula field be indexed?
I have a formula field called ContactID18__c on the Account object. The formula is CASESAFEID(PersonContact.Id). Can this field be indexed or no because it is a custom field and a formula? Or is ...
- 31