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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center