RDBPROD: Query Takes a Long Time to Complete and Appears to Use the Wrong Index

(Doc ID 444265.1)

Last updated on JULY 29, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0.9 and later
HP OpenVMS Itanium
HP OpenVMS Alpha


Running a particular query seems to take a long time to complete. Using the debug flags on the query shows that the optimizer has chosen the wrong index.


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