|
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.
ORDERED_TABLE_SCAN={ yes | no }
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.