My Oracle Support Banner

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 later
HP 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.