Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Connection String Parameters Reference

UltraLite DBKEY connection parameter Next Page

UltraLite ORDERED_TABLE_SCAN connection parameter

A backwards compatibility parameter. Controls whether queries access rows via a primary key index or from the database page directly. In versions of UltraLite previous to 10.0.1, UltraLite used the primary key index to return results when no other index was selected by the UltraLite optimizer.



Allowed values

All boolean values are supported. For example, true/false, yes/no, 1/0, and so on.


0, the database page is scanned directly (current UltraLite behavior).


If you want results returned with the row order of the primary key index, try to re-write 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 parameter if it is impractical to re-write your queries to use the ORDER BY clause.

See also