Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL elements reference » Execution plans in UltraLite

 

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.