View an execution plan in Interactive SQL when you need to know:
What index will be used to return the results. An index scan object contains the name of the table and the index on that table that is being used.
Whether a temporary table will be used to return the results. Temporary tables are written to the UltraLite temporary file. See UltraLite temporary files.
Which order tables are joined. This information allows you to determine how performance is affected.
Why a query is running slowly or to ensure that a query does not run slowly.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|