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 | where-clause }
Arguments
query-name- Name of the directed query to activate, as stored in the DIRECTED_QUERIES column
query_name. You can also use GET DIRECTED QUERY to obtain names of all directed queries that map to an input query. where-clause- Resolves to one or more directed queries that are filtered from system table DIRECTED_QUERIES. For example, the following statement activates all directed queries with the same
save_plans_versionidentifier:=> ACTIVATE DIRECTED QUERY WHERE save_plans_version = 21;
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.