Setting Hints in Annotated Queries

The hints in a directed query's annotated query provide the Vertica optimizer instructions how to execute an input query. Annotated queries support the following hints:

Other hints in annotated queries such as DIRECT or LABEL are ignored.

You can use hints in a vsql query the same as in an annotated query, with two exceptions: IGNORECONST and VERBATIM are invalid for use in vsql. For general information about using hints, see Hints in the SQL Reference Manual.