ACTIVATE DIRECTED QUERY
Activates a directed query and makes it available to the query optimizer across all sessions.
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. If omitted, Vertica activates the last-created directed query. To obtain identifiers for directed queries, use GET DIRECTED QUERY, or query the system table DIRECTED_QUERIES.
Privileges
SuperuserActivation 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.