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

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite Database Reference » UltraLite connection parameters

 

UltraLite ORDERED_TABLE_SCAN connection parameter [deprecated]

Controls whether queries access rows via a primary key index or from the database page directly.

Syntax
ORDERED_TABLE_SCAN={ yes | no }
Default

no (the database page is scanned directly)

Remarks

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.

See also