Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

per query allow reverse scan

Hi

Is it possible to add a parameter to a specific query in ASE (Currently 15.5 here) in order to allow reverse index scans ?

I know about the global server option, but its hard to give to all queries this capability

Does ASE store a pointer to the previous page to the index page?

There are some specific lookup queries i do need to collect the max for the latest version of a composite key

Im planning to do some tests to check this for how much LIOs are done, Hopefully adding it soon here

Thanks

Alexandre

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question