In my SOQL query in my Apex Batch start() methods I query and order
SELECT TextField__c
FROM MasterDetailChildWith4MillionRecords__c
WHERE Active__c = 'Yes'
AND Revenue__c != 0
AND Lookup__c = 'a1b50000000F6No'
ORDER BY UP2GO_2F__txt_DLV_DLIId__c
Master Detail child records. This query times out after 2 minutes. Where does this problem come from? From the schere size of records (4 millions) or the ORDER BY?
Any experiences or hints?
!=
the search has taken longer. Do you have any formula fields in the query? They are generated on the fly and slow down the search too.