Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235 7.1.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235 7.1.7 Parse Engine . . Batch Split . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 249 Optimization Rewrite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250 7.1.10 Execute The engine still in rapid development, basically available to users, but it still needs lots of optimization. It is an experimental product. Subquery Experimental supported when sharding keys are not

Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 245 7.2.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 245 7.2.7 Parse Engine . . Batch Split . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259 Optimization Rewrite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 260 7.2.10 Execute The engine still in rapid development, basically available to users, but it still needs lots of optimization. It is an experimental product. Subquery Experimental supported when sharding keys are not

Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 360 7.4.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 360 7.4.7 Parse Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 374 Rewriting for Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 375 7.4.10 Execute Engine . . . is still under development. Although largely available to users, it still requires significant optimization. Sub-query The Federation execution engine provides support for subqueries and outer queries

Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256 7.2.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256 7.2.7 Parse Engine . . Batch Split . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 270 Optimization Rewrite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 271 7.2.10 Execute The engine still in rapid development, basically available to users, but it still needs lots of optimization. It is an experimental product. Subquery Experimental supported when sharding keys are not

Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 499 12.4.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 499 12.4.7 Parse Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 513 Rewriting for Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 514 12.4.10 Execute Engine . . . is still under development. Although largely available to users, it still requires significant optimization. Sub-query The Federation execution engine provides support for subqueries and outer queries

Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 528 12.4.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 528 12.4.7 Parse Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 542 Rewriting for Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 543 12.4.10 Execute Engine . . . is still under development. Although largely available to users, it still requires significant optimization. Sub-query The Federation execution engine provides support for subqueries and outer queries

Parsing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 SQL Route . . . . . . all the three ShardingSphere products are identical. The core consists of SQL parsing => query optimization => SQL route => SQL rewrite => SQL execution => result merger. 3.1. Sharding 22 Apache ShardingSphere functions, pagination information, query conditions and placeholders that may be revised. Query Optimization It merges and optimizes sharding conditions, such as OR. SQL Route It is the sharding strategy

Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 387 7.4.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 387 7.4.7 Parse Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 401 Rewriting for Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 402 7.4.10 Execute Engine . . . is still under development. Although largely available to users, it still requires significant optimization. Sub-query The Federation execution engine provides support for subqueries and outer queries