Optimizer directives

Optimizer directives are comments that tell the query optimizer how to execute a query. You can use optimizer directives to improve query performance.