Re: Improve Query sqlm_9csc97utkgjub

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,
>
> 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
>
>
> 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
>

--
http://www.freelists.org/webpage/oracle-l