Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs

Questions tagged [indexing]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
11 votes
2 answers
1k 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 ...
Daniel Ballinger's user avatar
5 votes
2 answers
647 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 ...
AtulRajguru9's user avatar
  • 9,120
5 votes
2 answers
1k 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. ...
PartOfTheOhana's user avatar
2 votes
2 answers
8k 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 ...
Andre Green's user avatar