Directed Query

A saved set of instructions to the optimizer how to generate a query plan for a given query, in the form of SQL annotated with hints. A directed query pairs two components:

• Input query: A query that triggers use of this directed query when it is active.
• Annotated query: A SQL statement with embedded optimizer hints, which instruct the optimizer how to create a query plan for the specified input query.