My Oracle Support Banner

Database Index UK_SHP_PERSPECTIVE can cause performance issues (Doc ID 1628269.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Transportation Management - Version 6.2.8 and later
Information in this document applies to any platform.


During a load test a query was found to be slowly executing. It is the index that is causing it to perform poorly.
It's a system generated query as can be seen from the corresponding AWR and query ID.

Two workarounds were tried:

1. Add an index hint
2. Drop the index altogether

The 1st option can't be used since it is a system generated query and it's not known how it will take the index.
The 2nd option - dropping the index - showed a good result in the test, the execution time was drastically reduced.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.