Using index, prefetch, and lru | mru

The index, prefetch and lru | mru options specify the index, cache and I/O strategies for query execution. These options override the choices made by the SAP ASE optimizer. Use them with caution, and always check the performance impact with set statistics io on.

For more information about using these options, see the Performance and Tuning Guide.