1. Introduction
  2. Query Optimization
  3. Optimizer Hints

Optimizer Hints

You can apply hints to pass instructions to the TimesTen query optimizer. The optimizer considers these hints when choosing the best execution plan for your query.

You can apply hints as follows:

  • To apply a hint only for a particular SQL statement, use a statement level optimizer hint.

  • To apply a hint for an entire transaction, use a transaction level optimizer hint with the appropriate TimesTen built-in procedure.

  • To apply a hint for every SQL statement in the user application, use a connection level optimizer hint with the OptimizerHint connection attribute.

The order of precedence for optimizer hints is statement level hints, transaction level hints and then connection level hints.

See Use Optimizer Hints to Modify the Execution Plan in the Oracle TimesTen In-Memory Database Operations Guide.