+ Start a Discussion
Vijay NagarathinamVijay Nagarathinam 

Query performance.

Hi,

Can anyone know the considerations and query performance in salesforce?
LBKLBK
Hi Vijay,
SOQL can hardly be compared to SQL in terms of performance tuning.
One thing that could make or break an SOQL query (in terms of performance) is the indexes.
When we index the right fields and unindex the wrong fields, SOQL performance improves visibily.

Couple of links to read more on this topic.
https://developer.salesforce.com/forums/?id=906F00000008yjpIAA
https://developer.salesforce.com/blogs/engineering/2014/03/force-com-soql-best-practice-sort-optimization.html
https://help.salesforce.com/articleView?id=Checklist-for-Custom-Index-Requests&language=en_US&type=1