Technical data

Using the query optimizer
Tools for Troubleshooting TimesTen 1-21
executing SELECT statements on the columns or by using the ttIsql showplan
command, as described in "Viewing and changing query optimizer plans" in the Oracle
TimesTen In-Memory Database Operations Guide.
Using the query optimizer
The query optimizer is an important tool for performance tuning.
For details about using the query optimizer, see:
■ "The TimesTen Query Optimizer" in the Oracle TimesTen In-Memory Database
Operations Guide
■ "Viewing and changing query optimizer plans" in the Oracle TimesTen In-Memory
Database Operations Guide
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, as described in "Update
query optimizer statistics" on page 2-18. 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 plan generation" in the Oracle TimesTen In-Memory Database Operations
Guide.