ALTER SQL_FEDERATION RULE
语法用于修改联邦查询配置。
AlterSQLFederationRule ::=
'ALTER' 'SQL_FEDERATION' 'RULE' sqlFederationRuleDefinition
sqlFederationRuleDefinition ::=
'(' sqlFederationEnabled? allQueryUseSQLFederation? (','? executionPlanCache)? ')'
sqlFederationEnabled ::=
'SQL_FEDERATION_ENABLED' '=' boolean_
allQueryUseSQLFederation ::=
'ALL_QUERY_USE_SQL_FEDERATION' '=' boolean_
executionPlanCache ::=
'EXECUTION_PLAN_CACHE' '(' cacheOption ')'
cacheOption ::=
('INITIAL_CAPACITY' '=' initialCapacity)? (',' 'MAXIMUM_SIZE' '=' maximumSize)?
initialCapacity ::=
int
maximumSize ::=
int
boolean_ ::=
TRUE | FALSE
ALTER SQL_FEDERATION RULE (SQL_FEDERATION_ENABLED=TRUE ALL_QUERY_USE_SQL_FEDERATION=TRUE EXECUTION_PLAN_CACHE(INITIAL_CAPACITY=1024 MAXIMUM_SIZE=65535));
ALTER
、SQL_FEDERATION
、RULE
、SQL_FEDERATION_ENABLED
、ALL_QUERY_USE_SQL_FEDERATION
、EXECUTION_PLAN_CACHE
、INITIAL_CAPACITY
、MAXIMUM_SIZE