RDBPROD: A Query On A Very Large Table Using An Index Takes Too Long - Why?
(Doc ID 1336087.1)
Last updated on APRIL 14, 2022
Applies to:
Oracle Rdb Server on OpenVMS - Version 7.0 and laterHP OpenVMS Itanium
HP OpenVMS Alpha
Symptoms
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.
Changes
Table has grown significantly in size.
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |