:V
In a directed query, marks an input query constant that the optimizer ignores when it considers whether to use the directed query for a given query. Use this hint to create a directed query that can be used for multiple variants of an input query.
Vertica also supports IGNORECONST as an alias of :v . Optimizer-generated directed queries automatically mark predicate constants in input and annotated queries with :v hints.
For details, see Ignoring Constants in Directed Queries.
Syntax
/*+:v(arg)*//*+IGNORECONST(arg)*/
| arg |
Integer argument that is used in the directed query to pair each input query |