Re: Improve Query sqlm_9csc97utkgjub
Date: Thu, 24 Oct 2024 12:27:00 +0000 (UTC)
Message-ID: <1566077478.9412171.1729772820562_at_mail.yahoo.com>
Hallo Amit,
Best Regards,Petr
Am Mittwoch, 23. Oktober 2024 um 17:31:35 MESZ hat Amit Saroha <eramitsaroha_at_gmail.com> Folgendes geschrieben:
Hi Petr,Thank you for your feedback.The table is regularly updated. I mean, the latest update date column in a row changes every few minutes, so I'm not sure whether it's okay to establish an index on a column that's often changed.
Best Regards,AMIT
On Wed, Oct 23, 2024 at 11:22 AM Petr Novak <novak_petr_at_yahoo.de> wrote:
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
usually index should be still OK, but I dont know you system. It depends ..During full scan there were mostly sequential reads, so check chained rows in this table.Table reorganisation could make the full scan much faster. Then set lower pct_free for that table ?
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 Thu Oct 24 2024 - 14:27:00 CEST