Re: Improve SQL run time

Hi Lothar,

Thank you for the valuable feedback.

I'll make the adjustments provided in the example and see how things proceed.

Best Regards,
AMIT SAROHA On Mon, Oct 16, 2023 at 11:39 AM Lothar Flatz <l.flatz_at_bluewin.ch> wrote:

> Estimates are way wrong indexing could be improved.
> But since most of the time is spend on line 9-12 I would look first into
> elimination the select max(subquery) by using an analytic function as in
> this example:
>
>
> https://forums.oracle.com/ords/apexds/post/analytic-function-vs-subquery-8485
>
> Thanks
>
> Lothar
>
> Am 16.10.2023 um 17:07 schrieb Amit Saroha:
>
> Hi All,
>
> I'm executing the enclosed query and want to minimize the response time to
> 10 seconds. The SQL monitor, SQL, and SQL Plan are enclosed for your
> feedback.
>
> Please evaluate and provide feedback and if more information is needed,
> please let me know.
>
> Thank you for your help in advance.
>
> Best Regards,
> Amit
>
>
>

--
http://www.freelists.org/webpage/oracle-l