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.