RDBPROD: A Query On A Very Large Table Using An Index Takes Too Long - Why?

(Doc ID 1336087.1)

Last updated on AUGUST 09, 2016

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

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