OR 的情况下,执行计划如下:
Projection_9 19376062.00 root dwd.user_extend.uid, case(in(dwd.user_extend.reg_area, 912000000041844186, 0), dwd.user_first_location.quyubh, dwd.user_extend.reg_area)->Column#84, case(and(eq(dwd.user_extend.location_area, 0), not(isnull(dwd.user_first_location.regioncode))), dwd.user_first_location.regioncode, dwd.user_extend.location_area)->Column#85
└─Projection_10 19376062.00 root dwd.user_extend.uid, dwd.user_extend.reg_area, dwd.user_extend.location_area, dwd.user_first_location.quyubh, dwd.user_first_location.regioncode
└─IndexJoin_16 19376062.00 root inner join, inner:TableReader_13, outer key:dwd.user_first_location.weimaihao, inner key:dwd.user_extend.uid, equal cond:eq(dwd.user_first_location.weimaihao, dwd.user_extend.uid), other cond:or(ge(dwd.user_extend.update_time, 2023-03-06 00:00:00.000000), ge(dwd.user_first_location.update_time, 2023-03-06 00:00:00.000000))
├─TableReader_45(Build) 19376062.00 root data:Selection_44
│ └─Selection_44 19376062.00 cop[tikv] not(isnull(dwd.user_first_location.weimaihao))
│ └─TableFullScan_43 19398524.00 cop[tikv] table:b keep order:false
└─TableReader_13(Probe) 1.00 root data:TableRangeScan_12
└─TableRangeScan_12 1.00 cop[tikv] table:a range: decided by [dwd.user_first_location.weimaihao], keep order:false