-
Notifications
You must be signed in to change notification settings - Fork 18
Description
广播表a,分库不分表 tb_goods 拆分字段 member_id
数据库 icdb0,icdb1
icdb0 表 广播表 a

表 tb_goods

explain
select * from a,tb_goods as b where a.id=b.id and b.member_id=35
+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+
| GROUP_NAME | SQL | PARAMS |
+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+
| MYSQL_ICDB_01 | Join
leftColumns:[A.ID]
rightColumns:[B.MEMBER_ID]
type:inner join
strategy:NEST_LOOP_JOIN
executeOn:MYSQL_ICDB_01
left:
Query from A as A
tableName:a
executeOn:MYSQL_ICDB_00
right:
Query from TB_GOODS as B
resultFilter:TB_GOODS.MEMBER_ID = 35
tableName:tb_goods
executeOn:MYSQL_ICDB_01
| NULL |
+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+
1 row in set (0.19 sec)
理论上应该 下推到 MYSQL_ICDB_01
执行 sql的,怎么会在 icdb0上查询a ,在icdb1上查询tb_goods, 然后再在tddl上join的呢
