In Denodo 5.5, when I create a base view from a query Denodo doesn't seem to ever delegate that query to the data source, even when I include a restrictive where clause... and thus the query takes a long time to run.
In Denodo 6, it appears the default behavior is to wrap the query from the base view in a subquery and to then delegate it to the data source (the "Delegate Sub Query" Source Configuration seems to control this).
Thus, in Denodo 6, I've noticed that Denodo is able to take the same query it receives from my client application and run much much faster.
So, here is my question:
In Denodo 5.5, I've always told developers "Never use 'create base view from query' because of performance implications".
However, in Denodo 6, because of the subquery delegation, what should I tell my developers? "Avoid using 'create base view from query', but it might be okay to use it from time to time"?