Re: Discoverer Parameters

On Aug 27, 8:22 am, Eniacson <cesa..._at_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 Received on Mon Aug 27 2007 - 08:34:14 CDT