Using the Query Optimizer

The query optimizer is an important tool for performance tuning.

For details about using the query optimizer, see:

If you find that a given query runs more slowly than expected, confirm that the query optimizer has the latest statistics for the tables in your query. See Update Query Optimizer Statistics for more information. If, after updating your statistics, your query still runs too slowly, it is possible that the TimesTen optimizer is not choosing the optimal query plan to answer that query. Under these circumstances, you can adjust how the optimizer generates a plan by using the ttOpt procedures described in Modifying a SQL Query Execution Plan in the Oracle TimesTen In-Memory Database Operations Guide. You can also use statement level optimizer hints to influence the optimizer at the statement level. For more information, see Statement Level Optimizer Hints in the Oracle TimesTen In-Memory Database SQL Reference.