Access plan and query optimization guidelines

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.