I'm working on a Discoverer report (10g) that is required to include
in the result set all parameters provided, even when those parameters
are not found in the target tables; just like having an outer join on
the received parameters.
I simulated a parameter table using the Dual table and some
calculations on the discoverer side, but the response time increased
from five seconds (using regular parameters) to 5 minutes.
Any suggestions on how to obtain such a report with a good response
time would be appreciated.

On Aug 27, 8:22 am, Eniacson <cesa...@hotmail.com> wrote:
> I'm working on a Discoverer report (10g) that is required to include
> in the result set all parameters provided, even when those parameters
> are not found in the target tables; just like having an outer join on
> the received parameters.
> I simulated a parameter table using the Dual table and some
> calculations on the discoverer side, but the response time increased
> from five seconds (using regular parameters) to 5 minutes.
> Any suggestions on how to obtain such a report with a good response
> time would be appreciated.

Post the query you're currently using, including the explain plan.


David Fitzjarrell