RDBPROD: A Query On A Very Large Table Using An Index Takes Too Long - Why?
(Doc ID 1336087.1)
Last updated on DECEMBER 26, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document