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. |
