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 |
Privileges
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.