Improve SQL run time

From: Amit Saroha <eramitsaroha_at_gmail.com>
Date: Mon, 16 Oct 2023 11:07:23 -0400
Message-ID: <CAG67e6R+98Q-xRWHmaEsDcRBNLzEdPuDD5pxrDTn95M68GFSJA_at_mail.gmail.com>

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





text/plain attachment: Header_View_Query.sql.txt



text/html attachment: sqlm_119kfq6544x4d.html

Received on Mon Oct 16 2023 - 17:07:23 CEST

This message: [ Message body ]
Next message: Asad: "Re: Improve SQL run time"
Previous message: Mladen Gogala: "Re: Question on SQL Server to MySQL DB migration"
Next in thread: Asad: "Re: Improve SQL run time"
Reply: Asad: "Re: Improve SQL run time"
Reply: Lothar Flatz: "Re: Improve SQL run time"
Reply: Timur Akhmadeev: "Re: Improve SQL run time"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message