RDBPROD: A Query On A Very Large Table Using An Index Takes Too Long - Why?
Last updated on AUGUST 09, 2016
Applies to:Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS Itanium
HP OpenVMS Alpha
A query that uses an appropriate index on a table containing millions of rows is taking longer and longer over time. A response time in excess of 40 minutes on a 100 million row table has been observed.
Table has grown significantly in size.
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