SHOW SQL_FEDERATION RULE

Description

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

Syntax

Grammar Railroad diagram

  1. ShowSQLFederationRule ::=
  2.   'SHOW' 'SQL_FEDERATION' 'RULE'

Return Value Description

ColumnDescription
sql_federation_enabledSQL federation enabled configuration
all_query_use_sql_federationall query use SQL federation configuration
execution_plan_cacheexecution plan cache configuration

Example

  • Query sql federation rule configuration
  1. SHOW SQL_FEDERATION RULE;
  1. mysql> show sql_federation rule;
  2. +------------------------+------------------------------+-------------------------------------------+
  3. | sql_federation_enabled | all_query_use_sql_federation | execution_plan_cache                      |
  4. +------------------------+------------------------------+-------------------------------------------+
  5. | true                   | false                        | initialCapacity: 2000, maximumSize: 65535 |
  6. +------------------------+------------------------------+-------------------------------------------+
  7. 1 row in set (0.31 sec)

Reserved word

SHOW、SQL_FEDERATION、RULE