LABEL

Assigns a label to a statement in order to identify it for profiling and debugging.

LABEL hints are valid in the following statements:

• DELETE
• INSERT
• MERGE
• SELECT
• UPDATE
• UNION: Valid in the UNION's first SELECT statement. Vertica ignores labels in subsequent SELECT statements.

Syntax

statement-name /*+ LABEL (label‑string) */

Arguments

Examples

=> SELECT /*+ LABEL(MySelectQuery)*/ COUNT(*) FROM t;
=> INSERT /*+ LABEL('Yet Another Query')*/ INTO t VALUES(1);

See Also

Labeling Queries in the Administrator's Guide