Skip to Content

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

per query allow reverse scan


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



Former Member

Helpful Answer

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