Optimize Data Queries for Data Queues
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms