Formula Fields or Relationships in the Queries ?

Question

Hi All,

What is the best way in terms of performace, defining a formula field for related objects or using the clause __r directly in the query ?

Which one is the best approach ?

e.g:

Select Id, Name From Object where Custom_Formula_Field__c = 'Any'
Select Id, Name From Object where Custom Related_Object__r.Custom_Field__c = 'Any'

Many thanks!

Amit Chaudhary · Accepted Answer

Never use fomual field in SOQL in where as per salesforce best pratice.

2nd option is good one.

Please let us know if this will help you.

Thanks

Amit Chaudhary

Apex