Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index on CORRID

jmjacobsMar 7 2011 — edited Mar 11 2011

Queue table with one queue, dequeuing using correlation ID.

Added an index on CORRID, but it is not being used by the execution plan.

Is there any way to get AQ to use the index, other than gathering statistics on the queue table? (I'm assuming that gathering statistics will work, as the correlations ID are all string with no wildcard character, wide range of values for the correlation ID, single value for the queue name, but have to wait for a suitable opportunity to gather and test).

Oracle 10.2.0.4

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 8 2011

Added on Mar 7 2011

#advanced-queueing, #database-key-features, #index

1 comment

469 views