用in条件的时候特别慢,改为关联会好很多,但我只在select 的时候用过关联,不知道update 的时候能不能用,如下面这句:update info_customer t set (dept_no,customer_no)
=(select dept_no,customer_no from p_info_customer t1 where t1.rowid=t.tibco_pk) where t.tibco_pk in (select tibco_pk from info_customer_temp t2 where to_char(create_date,'mmdd')='0116')
=(select dept_no,customer_no from p_info_customer t1 where t1.rowid=t.tibco_pk) where t.tibco_pk in (select tibco_pk from info_customer_temp t2 where to_char(create_date,'mmdd')='0116')
=(select dept_no,customer_no from p_info_customer t1 where t1.rowid=t.tibco_pk)
where exists (select 'X' from info_customer_temp t2 where to_char(create_date,'mmdd')='0116' and t.tibco_pk=t2.tibco_pk)