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_qtyfrom zh_ads.ads_mfg_working_inv_detail org,zh_ods.ods_dj_portal_user_data_permission pwhere 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