primary table and the joiner table with the same sharding rules. for example, t_order and t_order_item are both sharded by order_id, so they are binding tables with each other. Carte‐ sian product correlation will increase greatly. Take this one for example, if SQL is: SELECT i.* FROM t_order o JOIN t_order_item i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); When binding table relations are not configured o JOIN t_order_item_0 i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); 4.2. Sharding 24 Apache ShardingSphere document, v5.0.0 SELECT i.* FROM t_order_0 o JOIN t_order_item_1 i ON o.order_id=i

Properties Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 128 v Configuration Item Explanation . . . . . . . . . . . . . . . . . . . . . . . . . . . 129 5.1.7 Builtin Algorithm . cross‐database correlation will appear, which will affect query efficiency. For example, t_order and t_order_item are both sharded by order_id, and use order_id to correlate, so they are binding tables with each will increase greatly. Take this one for example, if SQL is: SELECT i.* FROM t_order o JOIN t_order_item i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); When binding table relations are not configured

Properties Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124 Configuration Item Explanation . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 5.1.6 Builtin Algorithm . cross‐database correlation will appear, which will affect query efficiency. For example, t_order and t_order_item are both sharded by order_id, and use order_id to correlate, so they are binding tables with each will increase greatly. Take this one for example, if SQL is: SELECT i.* FROM t_order o JOIN t_order_item i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); When binding table relations are not configured

primary table and the joiner table with the same sharding rules, for example, t_order and t_order_item are both sharded by order_id, so they are binding tables with each other. Carte‐ sian product correlation will increase greatly. Take this one for example, if SQL is: SELECT i.* FROM t_order o JOIN t_order_item i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); When binding table relations are not configured routing: SELECT i.* FROM t_order_0 o JOIN t_order_item_0 i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); SELECT i.* FROM t_order_0 o JOIN t_order_item_1 i ON o.order_id=i.order_id WHERE o. order_id

association will occur, affecting query efficiency. For example, if the t_order table and t_order_item table are both sharded according to order_id and are correlated using order_id, the two tables are SQL is: 8.1. Sharding 23 Apache ShardingSphere document SELECT i.* FROM t_order o JOIN t_order_item i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); In the case where no binding table relationships product: SELECT i.* FROM t_order_0 o JOIN t_order_item_0 i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); SELECT i.* FROM t_order_0 o JOIN t_order_item_1 i ON o.order_id=i.order_id WHERE o. order_id

association will occur, affecting query efficiency. For example, if the t_order table and t_order_item table are both sharded according to order_id and are correlated using order_id, the two tables are SQL is: 8.1. Sharding 23 Apache ShardingSphere document SELECT i.* FROM t_order o JOIN t_order_item i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); In the case where no binding table relationships product: SELECT i.* FROM t_order_0 o JOIN t_order_item_0 i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); SELECT i.* FROM t_order_0 o JOIN t_order_item_1 i ON o.order_id=i.order_id WHERE o. order_id

association will occur, affecting query efficiency. For example, if the t_order table and t_order_item table are both sharded according to order_id and are correlated using order_id, the two tables are 3.1. Sharding 20 Apache ShardingSphere document, v5.2.0 SELECT i.* FROM t_order o JOIN t_order_item i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); In the case where no binding table relationships product: SELECT i.* FROM t_order_0 o JOIN t_order_item_0 i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); SELECT i.* FROM t_order_0 o JOIN t_order_item_1 i ON o.order_id=i.order_id WHERE o. order_id

卡尔积关联或跨库关联，从而影响查询效率。例如：t_order 表和 t_order_item 表，均按照 order_id 分片，并且使用 order_id 进行关联，则此两张表互为绑定表关系。绑定表之间的多表关联查询不会出 现笛卡尔积关联，关联查询效率将大大提升。举例说明，如果 SQL 为： SELECT i.* FROM t_order o JOIN t_order_item i ON o.order_id=i.order_id 条，它们呈现为笛卡尔积： SELECT i.* FROM t_order_0 o JOIN t_order_item_0 i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); SELECT i.* FROM t_order_0 o JOIN t_order_item_1 i ON o.order_id=i.order_id WHERE o. order_id 11); SELECT i.* FROM t_order_1 o JOIN t_order_item_0 i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); SELECT i.* FROM t_order_1 o JOIN t_order_item_1 i ON o.order_id=i.order_id WHERE o. order_id

卡尔积关联或跨库关联，从而影响查询效率。例如：t_order 表和 t_order_item 表，均按照 order_id 分片，并且使用 order_id 进行关联，则此两张表互为绑定表关系。绑定表之间的多表关联查询不会出 现笛卡尔积关联，关联查询效率将大大提升。举例说明，如果 SQL 为： SELECT i.* FROM t_order o JOIN t_order_item i ON o.order_id=i.order_id 条，它们呈现为笛卡尔积： SELECT i.* FROM t_order_0 o JOIN t_order_item_0 i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); SELECT i.* FROM t_order_0 o JOIN t_order_item_1 i ON o.order_id=i.order_id WHERE o. order_id 11); SELECT i.* FROM t_order_1 o JOIN t_order_item_0 i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); SELECT i.* FROM t_order_1 o JOIN t_order_item_1 i ON o.order_id=i.order_id WHERE o. order_id

association will occur, affecting query efficiency. For example, if the t_order table and t_order_item table are both sharded according to order_id and are correlated using order_id, the two tables are 3.1. Sharding 19 Apache ShardingSphere document, v5.2.1 SELECT i.* FROM t_order o JOIN t_order_item i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); In the case where no binding table relationships product: SELECT i.* FROM t_order_0 o JOIN t_order_item_0 i ON o.order_id=i.order_id WHERE o. order_id in (10, 11); SELECT i.* FROM t_order_0 o JOIN t_order_item_1 i ON o.order_id=i.order_id WHERE o. order_id