摘要： DECLARE maxrows number default 5000; row_id_table dbms_sql.Urowid_Table; p_id_table dbms_sql.Varchar2_Table; CURSOR acnt_first_cur IS SELECT/*+ use_hash(t1,t2) parallel(t1,4) parallel(t2,4) */ t2.service_type, t1.rowid FROM kfgl_p_web_access_t9 t1,LC_CP.b_serv_t@TO_HUBEI_ODS1_T t2 WHER... 阅读全文

摘要： 为了加快表字段的打标采用了多CPU并行的方式取数：SELECT/*+ use_hash(t1,t2) parallel(t1,4) parallel(t2,4) */ t2.service_type, t1.rowidFROM '||v_table_name||' t1,LC_CP.b_serv_t@TO_HUBEI_ODS1_T t2 WHERE t1.acc_nbr = t2.acc_nbr AND t2.state = ''F0A'' AND t1.par_id ='||v_day_id||' ORDER BY t1.row 阅读全文