案例1
explain analyze
select t1.user_id,t2.cust_curr_bal,cust_distr_amt from dtl.t_gm_ec_lon_dubil t1 left join(select
user_id – 客户编号
,sum (ifnull (curr_bal,0)) as cust_curr_bal --汇总到客户的贷款余额
,sum (distr_amt) as cust_distr_amt --汇总到客户的放款金额
from dt1.t_gm_ec_lon_dubil --小微贷款明细
where data_dt - date_format(‘20241231’,‘%Y-%m-%d’)–20210615 将网商批处理改为次日下午 group by user_id) t2
on t1.user ide2.user_id 0 ta_at - date_format(‘20241231’.‘%Y-m-d’)
–案例2
explain analyze select
user_id – 客户编号
.sum (ifnull (curr_ba1, 0)) over (partition by user_id order by lp_id,dubil_id) as cust_curr_bal – 汇总到客户的贷款余额
,sum (distr_ant ) over (partition by user_id order by lp_id,dubil_id) as cust_distr_amt – 汇总到客户的放款金额
from dt1.t_gm_ec_1on_dubil 小微贷款明细
where data_dt- date_format('20241231’,‘Y-%m-&d’)-- 20210615将网商批处理改为次日下午
查询结果一致，在性能方面案例1和案例2哪一个更优一点
执行计划贴出来吧，只看语句也看不出来。