We are using DB Adapter poller to poll 50 records from table order by one column "EEVNT_ID".
The expected action is to sort the records in ascending order based on EVENT_ID from the table and then to return the first 50 records.
But the actual behavior noticed is, 50 records being picked randomly and then these records are being sorted in ascending order.
We identified this using the DB AWR report. Is there any way within the adapter to prioritize the execution in a way that it will sort the records first and then poll the first 50 records?
Any suggestions at the earliest would be much appreciated.