Error - too many rows examined
We got the below error when we execute the below API in our OIC integration. We execute the below API EOD everyday and we pass the current date to the API. Max 500 records might be returned.
API: https://abcd.custhelp.com/services/rest/connect/v1.3/queryResults/?query=select id from abc.WorkOrder where UpdatedTime >= '<TodayDate>T00:00:00Z'
Error: This query is not supported: Poor performing query - too many rows examined
I could not see the option to index the updatedTime field in our custom object.
How to fix this issue?