Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Release Notes

Index Operations

The following table shows some of the common index operations you may encounter while using the Explain SQL window.

Operation Option Description

AND-EQUAL

  

The results from one or more index scans are combined.

INDEX

UNIQUE SCAN

An index lookup that returns the address (ROWID) of only one row.

INDEX

RANGE SCAN

An index lookup that returns the ROWID of more than one row. This may be because the index is non-unique, or because a range operator (for example, >) was used.

 

Related Topics

Tools | Explain Plan

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating