DEACTIVATE DIRECTED QUERY
Deactivates one or more directed queries previously activated by ACTIVATE DIRECTED QUERY.
Deactivates one or more directed queries previously activated by ACTIVATE DIRECTED QUERY.
Syntax
DEACTIVATE DIRECTED QUERY { query-name | input-query | where-clause }
Arguments
query-name- Name of the directed query to deactivate, as stored in the DIRECTED_QUERIES column
query_name. input-query- The input query of the directed queries to deactivate. Use this argument to deactivate multiple direct queries that map to the same input query.
where-clause- Resolves to one or more directed queries that are filtered from system table DIRECTED_QUERIES. For example, the following statement specifies to deactivate all directed queries with the same
save_plans_versionidentifier:=> DEACTIVATE DIRECTED QUERY WHERE save_plans_version = 21;