Re: Improve Query sqlm_9csc97utkgjub
From: Petr Novak <"Petr>
Date: Wed, 23 Oct 2024 15:22:30 +0000 (UTC)
Message-ID: <1478451429.8829791.1729696950767_at_mail.yahoo.com>
Date: Wed, 23 Oct 2024 15:22:30 +0000 (UTC)
Message-ID: <1478451429.8829791.1729696950767_at_mail.yahoo.com>
Hallo Amit,
Am Mittwoch, 23. Oktober 2024 um 17:02:56 MESZ hat Amit Saroha <eramitsaroha_at_gmail.com> Folgendes geschrieben:
Hi All,I am requesting that you check the included SQL monitoring data and let me know if there is anything we can do to optimize the run time.
Thank you for your assistance and advice in advance.
Best Regards,AMIT
Table OE_ORDER_LINES_ALL - can you create index on LAST_UPDATE_DATE ?Check also percentage of chained rows in this table.
Best Regards,Petr
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 23 2024 - 17:22:30 CEST