When to view an execution plan
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.