ALTER SQL_FEDERATION RULE

Description

The ALTER SQL_FEDERATION RULE syntax is used to modify the federated query configuration.

Syntax

Grammar Railroad diagram

  1. AlterSQLFederationRule ::=
  2.   'ALTER' 'SQL_FEDERATION' 'RULE' sqlFederationRuleDefinition
  4. sqlFederationRuleDefinition ::=
  5.   '(' sqlFederationEnabled? allQueryUseSQLFederation? (','? executionPlanCache)? ')'
  7. sqlFederationEnabled ::=
  8.   'SQL_FEDERATION_ENABLED' '=' boolean_
  10. allQueryUseSQLFederation ::=
  11.   'ALL_QUERY_USE_SQL_FEDERATION' '=' boolean_
  13. executionPlanCache ::=
  14.   'EXECUTION_PLAN_CACHE' '(' cacheOption ')'
  16. cacheOption ::=
  17.   ('INITIAL_CAPACITY' '=' initialCapacity)? (',' 'MAXIMUM_SIZE' '=' maximumSize)?
  19. initialCapacity ::=
  20.   int
  22. maximumSize ::=
  23.   int
  25. boolean_ ::=
  26.   TRUE | FALSE

Example

  • Alter SQL Federation rule
  1. ALTER SQL_FEDERATION RULE (SQL_FEDERATION_ENABLED=TRUE ALL_QUERY_USE_SQL_FEDERATION=TRUE EXECUTION_PLAN_CACHE(INITIAL_CAPACITY=1024 MAXIMUM_SIZE=65535));

Reserved word

ALTER、SQL_FEDERATION、RULE、SQL_FEDERATION_ENABLED、ALL_QUERY_USE_SQL_FEDERATION、EXECUTION_PLAN_CACHE、INITIAL_CAPACITY、MAXIMUM_SIZE