Converse agora com nosso suporte
Chat com o suporte

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

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação