update cbs_contractlife set back_date =to_date('2014-11-17','yyyy-mm-dd') where policy_code ='6663131080120140003518' and status ='1';
update cbs_receiptinfo set back_date = to_date('2015-10-13','yyyy-mm-dd') where policy_id = (select policy_id from cbs_contractlife where policy_code ='9251645A75515000808' ) and rec_type ='0';
就这两个sql,只不过量比较大,三万条,好吧也不是很大,但是oracle要跑40分钟,然后两道就不乐意了,这要怎么改啊,要创建新的表吗