UltraLite execution plans show how tables and indexes are accessed when a query is executed. UltraLite includes a query optimizer. The optimizer is an internal component of the UltraLite runtime that attempts to produce an efficient plan for the query. It tries to avoid the use of temporary tables to store intermediate results and attempts to ensure that only the pertinent subset of a table is accessed when a query joins two tables.
The optimizer always aims identify the most efficient access plan possible, but this goal is not guaranteed—especially with
a complicated query where a great number of possibilities may exist. In extreme cases, you can override the table order it
selects by adding the
OPTION (FORCE ORDER) clause to a query, which forces UltraLite to access the tables in the order they appear in the query. This option is not recommended for general use. If performance is slow, a better approach is usually to create appropriate indexes to speed up execution.
If you are not going to update data with the query, you should specify the FOR READ ONLY clause in your query. This clause may yield better performance. See UltraLite SELECT statement.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|