Optimization guidelines are rules
that you create to control the decisions made during the optimization
stages of query compilation. These guidelines are recorded and used
by an optimization profile. Guidelines can be written at the global
level or statement level.
Many query compiler decisions
can be controlled through the creation of optimization guidelines.