SQL Performance
From: Amit Saroha <eramitsaroha_at_gmail.com>
Date: Tue, 12 Mar 2024 10:38:44 -0400
Message-ID: <CAG67e6TR+VT7rMPXj__AgotNi+KodxNtZ8RfWU4h6-q1mvnJLQ_at_mail.gmail.com>
Hi All,
I have the enclosed query running rather slowly, and I'd like to enhance it such that it finishes in a few seconds. The query is a SELECT statement on a view and I enclosed the view text.
Please review the accompanying query and monitoring report and provide input for improvements.
I appreciate your aid and support in advance.
AMIT
Date: Tue, 12 Mar 2024 10:38:44 -0400
Message-ID: <CAG67e6TR+VT7rMPXj__AgotNi+KodxNtZ8RfWU4h6-q1mvnJLQ_at_mail.gmail.com>
Hi All,
I have the enclosed query running rather slowly, and I'd like to enhance it such that it finishes in a few seconds. The query is a SELECT statement on a view and I enclosed the view text.
Please review the accompanying query and monitoring report and provide input for improvements.
I appreciate your aid and support in advance.
Best Regards,
AMIT
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 12 2024 - 15:38:44 CET
- text/plain attachment: view_definition.txt
- text/html attachment: sqlm_4m9sr2tx3k5a9.html