How do I perform predicate pushdown optimization in IRIS embedded SQL with dynamic joins? Body:
When writing dynamic SQL queries using embedded SQL, how can I force or ensure that filter conditions are pushed down to the data access layer rather than evaluated in memory?