Optimize Data Queries for Data Queues (Doc ID 2192056.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle Transportation Management - Version 6.3.4 and later
Oracle Global Trade Management - Version 6.3.4 and later
Oracle Global Trade Management Cloud Service - Version 6.3.4 and later
Oracle Transportation Management Cloud Service - Version 6.3.4 and later
Information in this document applies to any platform.

Goal

Your implementation makes heavy use of data queues on table Q_INTEGRATION_IN.

Upon analysis you find that query performance could be improved because the most efficient index on the table IX_Q_INT_IN_Q_STATE is not always used by the cost based optimizer.

To guarantee consistent good performance, you'd like to add an index hint to the queries so that the preferred index is always used.


Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms