My Oracle Support Banner

Fake Indexes in Oracle RDBMS (Doc ID 329457.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 10.1.0.2 [Release 8.1.7 to 10.1]
Information in this document applies to any platform.
Oracle RDBMS 8i, 9i and 10g.


Purpose

This Note explains the concept of Fake Indexes and the causes of error ORA-8114.  These are also sometimes called Virtual Indexes.

Scope

The Oracle Enterprise Manager Tuning Wizard examines the impact on execution plans in case new indexes are created.  In order to do so, it creates a fake or virtual index on the database and checks if the new index will be used by the CBO.  Thus, it basically tricks the optimizer into believing that an index exists and generates an appropriate execution plan which enables the Enterprise Manager to analyze whether the presence of the index is going to impact the present execution plan.  Since there is no storage area associated with these indexes, they do not have any other overhead.  These fake indexes can also be used via standalone SQL*Plus.

Details

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
Purpose
Scope
Details

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