Controls whether queries access rows via a primary key index or from the database page directly.
ORDERED_TABLE_SCAN={ yes | no }
no (the database page is scanned directly)
If you want results returned with the row order of the primary key index, rewrite your queries to include the ORDER BY clause first. Otherwise, you cannot take advantage of the performance benefits introduced by allowing direct page scans for this connection. Only use this connection parameter if it is impractical to re-write your queries to use the ORDER BY clause.
In versions 10.0.0 and earlier of UltraLite, UltraLite used the primary key index to return results when no other index was selected by the UltraLite optimizer.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |