Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Query Processing » Query optimization and execution » Query execution algorithms » Table access methods

 

IndexOnlyScan method (IO)

When an index used by the optimizer contains all the data from the underlying table that is required to satisfy the query, it may be possible to completely avoid reading values from the underlying table and retrieve the data directly from the indexes. This is referred to as an index-only retrieval. Index-only retrievals reduce the amount of I/O and cache required to satisfy a query, and improve performance. The optimizer performs an index only retrieval whenever possible.

See also