Timesten - Query Plan

Timesten Component

About

The query plan in TT

How to

view a plan

  • with an explain
  • in the SYS.PLAN table (after a prepare or an explain)

modify an execution plan

Applications can modify an execution plan by providing hints to the optimizer. Hints are specified by calls to one of the TimesTen optimizer built-in procedures which all start with ttOpt.

  • ttOptSetFlag—Sets certain optimizer flag See for a list of flag.
  • ttOptSetOrder—Enables an application to specify the table join order.
  • ttOptUseIndex—Enables an application to specify that an index be used or to disable the use of certain indexes.
  • ttOptClearStats, ttOptEstimateStats, ttOptSetColIntvlStats, ttOptSetTblStats, ttOptUpdateStats—Manipulate statistics that the TimesTen Data Manager maintains on the application's data that are used by the query optimizer to estimate costs of various operations.

See the last Timesten reference documentation for the built-in documentation.

Operations

full table scan

  • TblLkSerialScan - full table scan with Table lock
  • RowLkSerialScan - full table scan with Row Lock





Discover More
Timesten Component
Timesten - How to explain a query plan ? (Explain command|ttSqlCmdQueryPlan)

To explain a query and show a query plan, you can use: The ttIsql explain command for an individual SQL command. or the ttSqlCmdQueryPlan built-in procedure you get it from command cache (the...



Share this page:
Follow us:
Task Runner