JDev/ADF sample - Proactively Controlling ADF Query Execution with Estimated Row Count

• Proactively Controlling ADF Query Execution with Estimated Row Count. In ADF BC we can configure how many rows VO should return, however in the background it still will execute entire SQL statement without attaching rownum < X to it. We can prevent this by overriding executeQueryForCollection method and checking estimated row count, before invoking actual SQL statement.

Download - ADFProactiveQueryPerformance.zip