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