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

label‑string

A string that is up to 128 octets long. If enclosed with single quotes, label‑string can contain embedded spaces.

Examples

See Labeling Queries in the Administrator's Guide.