Re: Improve SQL run time

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