Apply Statement Level Optimizer Hints for a SQL Statement

A statement level optimizer hint is a specially formatted SQL comment containing instructions for the SQL optimizer.

A statement level optimizer hint can be specified within the SQL statement that it is to be applied against with one of the following methods:

• /*+ */ The hints can be defined over multiple lines. The hints must be enclosed in the comment syntax. The plus sign (+) denotes the start of a hint.

• --+ The hint must be defined on a single line after the plus sign (+).

The statement level optimizer hint can be specified in the SELECT, INSERT, UPDATE, MERGE, DELETE, CREATE TABLE AS SELECT, or INSERT ... SELECT statements. You must specify the hint within comment syntax immediately following the SQL VERB.

If you specify any statement level optimizer hints incorrectly, TimesTen ignores these hints and does not provide an error. If you define conflicting hints, the rightmost hint overrides any conflicting hints for the statement.

See Statement Level Optimizer Hints in the Oracle TimesTen In-Memory Database SQL Reference for information specific to statement level optimizer hints.