Re: Improve Query sqlm_9csc97utkgjub

Thank you everyone for your inputs. I will work towards the suggestions.

Best Regards,
AMIT On Thu, Oct 24, 2024 at 8:27 AM Petr Novak <novak_petr_at_yahoo.de> wrote:

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