This function is an experimental one and is currently not suitable for use in core system production environments. When multiple tables in a join query are distributed across different database instances, enabling federated query allows for cross-database join queries, as well as subqueries.
sqlFederation:
sqlFederationEnabled: # SQL federation enabled configuration
allQueryUseSQLFederation: # all query use SQL federation configuration
executionPlanCache: # execution plan cache configuration
initialCapacity: 2000 # execution plan local cache initial capacity
maximumSize: 65535 # execution plan local cache maximum size
sqlFederation:
sqlFederationEnabled: true
allQueryUseSQLFederation: false
executionPlanCache:
initialCapacity: 2000
maximumSize: 65535