Oracle hint

with as hint materialize 临时表物化;

use_nl(tbA tbB) nestloop ;

INDEX(T IDX_BIL_WAYBILL_TEMP_EXP_01)

 

-- 让程序暂停1秒,类似于java线程?
DBMS_LOCK.SLEEP(1);