[CR #401543] The configuration parameter allow backward scan does not work in Adaptive Server version 15.0.
Workaround: If you are encountering increased deadlocks due to backward scans, break problematic descending scans into two steps. First, select the required rows into a temporary table in ascending order. Then, select from the temporary table in descending order.
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |