Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on Oracle 10.10 - 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

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation