请教下给位 最近flink sql 关联维度表 非常慢 SELECT cc.us #Flink

请教下给位 最近flink sql 关联维度表 非常慢 SELECT cc.user_id,h.etime,h.market,cc.fund_account FROM source_stock_code h JOIN stock_account_dim FOR SYSTEM_TIME AS OF h.proc_time cc ON h.code = stockformat(cc.stock_code,cc.exchange_type) and filtercode(h.code,h.market) AND h.market=if(cc.exchange_type=0,'hk',if(cc.exchange_type=5,'us','sz')) AND cc.valid=1 JOIN margin_info_dim FOR SYSTEM_TIME AS OF h.proc_time mi ON cc.user_id = mi.user_id AND cc.fund_account = mi.margin_account GROUP BY cc.user_id,h.etime,h.market,cc.fund_account

这个 sql 如何优化 #Flink