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.