What is a query hint used for?

What is a query hint used for?

• A. Overrides the default behavior of the query optimizer
• B. Specifies the user permissions for a query
• C. Indicates the data type of each column
• D. Provides a description of the query for auditing

Answer: (A)

A query hint is a directive embedded in a SQL statement that nudges the optimizer toward a chosen execution path. By using hints, you can override the optimizer’s default decisions—such as which index to use, the join method, or the join order—so the plan that runs matches what you know about the data and workload. This is why it’s the best match: hints are specifically about influencing how the query is executed, rather than about permissions, data types, or auditing. Permissions are handled with grants, data types come from column definitions, and auditing is a separate feature. Hints give you control to tailor performance when the automatic plan isn’t ideal, though they should be used judiciously since data changes can make a hinted plan less effective.

A query hint is a directive embedded in a SQL statement that nudges the optimizer toward a chosen execution path. By using hints, you can override the optimizer’s default decisions—such as which index to use, the join method, or the join order—so the plan that runs matches what you know about the data and workload.

This is why it’s the best match: hints are specifically about influencing how the query is executed, rather than about permissions, data types, or auditing. Permissions are handled with grants, data types come from column definitions, and auditing is a separate feature. Hints give you control to tailor performance when the automatic plan isn’t ideal, though they should be used judiciously since data changes can make a hinted plan less effective.