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

SQL Anywhere 12.0.1 » UltraLite - Database Management and Reference » UltraLite performance tips » Query performance tips » 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.

  • 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.

 See also