clickhouse 数据库 两张表关联运行超过30s，怎么优化 select data_date,base_name2,customer_name,product_name,product_type,item_code,item_name,sap_working_qty,pass_qty,pitem_cost_qty,made_qty from zh_ads.ads_mfg_working_inv_detail org ,zh_ods.ods_dj_portal_user_data_permission p where 1=1 and p.username = '${fine_username}' and p.del_flag='0' and p.permission_type<'4' and region_name = '制造域' and if(p.base_flag is NULL,1=1,p.base_flag = org.base_code ) ${if(len(数据日期)=0,""," and data_date= '"+ 数据日期 +"'")} ${if(len(基地名称)==0,"","and base_name2 in ('" + 基地名称 +"')")} ${if(len(客户)==0,"","and customer_name in ('" + 客户 +"')")} ${if(len(成品物料描述)==0,"","and product_name in ('" + 成品物料描述 +"')")} ${if(len(成品类型)==0,"","and product_type in ('" + 成品类型 +"')")} ${if(len(物料)==0,"","and item_code in ('" + 物料 +"')")} order by base_name2,customer_name,product_name,product_type,item_code,item_name,data_date DESC | 
1min目标场景问卷
立即参与
