index, prefetch, and lru | mru 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.