+ Start a Discussion
theitdeptrockstheitdeptrocks 

Query and Index Questions

In some areas of our site, we’re being killed by a delay that comes from querying Salesforce.  Does anyone have any recommendations, tricks, or advice on how to reduce that delay?

 

1)  When querying data directly from Salesforce, particularly when doing a JOIN, how can you be certain you’re using an “indexed” field?

2)  Are certain fields automatically indexed?

3)  Can you create indexes?

 

Ritesh AswaneyRitesh Aswaney

Id and ExternalId fields are auto-indexed.

I believe marking a field as an External Id causes an Index to be created on it.