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