ACTIVATE DIRECTED QUERY

Activates a directed query and makes it available to the query optimizer across all sessions.

Syntax

ACTIVATE DIRECTED QUERY query‑name

Parameters

query‑name

Identifies the directed query to activate. To obtain identifiers for directed queries, use GET DIRECTED QUERY, or query the system table V_CATALOG.DIRECTED_QUERIES.

Privileges

Superuser

Activation Life Cycle

After you activate a directed query, it remains active until it is explicitly deactivated by DEACTIVATE DIRECTED QUERY or removed from storage by DROP DIRECTED QUERY. If a directed query is active at the time of database shutdown, Vertica automatically reactivates it when you restart the database.

Examples

See Activating and Deactivating Directed Queries.