I have the below SOQL query which is performing poorly in my Informatica job:
SELECT Job__c.Id , Job__c.Name , Job__c.Case__r.Id , Job__c.Case__r.Account.RecordTypeId , Job__c.Case__r.Account.AccountNumber , Job__c.Case__r.RecordType.Name , Job__c.Case__r.Contract_New__r.Name , Job__c.Claim_Payee__r.Id FROM Job__c Where (Case__r.CSR_Integration_Status__c = 'In Process')
Is the best way to query records on the parent? Would something like:
where Job__c.Case__r.CSR_Integration_Status__c = 'In Process' perform better or is it the same?
Also what is the performance impact of having all these relationships to other objects in my query? I think that could hurt my performance, but I'm not sure of the best way to test query performance.
Thank you, Ian