Key Tuning Parameters in theONCONFIG File

Optimizer Index Hint

OPTCOMPIND 2 # To hint the optimizer

# OPTCOMPIND

# 0 => Nested loop joins will be preferred (where

# possible) over sortmerge joins and hash joins.

# 1 => If the transaction isolation mode is not

# "repeatable read", optimizer behaves as in (2)

# below. Otherwise it behaves as in (0) above.

# 2 => Use costs regardless of the transaction isolation

# mode. Nested loop joins are not necessarily

# preferred. Optimizer bases its decision purely

# on costs.

Previous slide

Next slide

Back to first slide

View graphic version