供应链sit oracle 服务器并行线程64最快

SELECT *   FROM SCM_IO_LIS_LOG_TBL t    WHERE 1 = 1  
          order by t.insert_datetime asc

23.221s

SELECT/*+parallel(4) */ *   FROM SCM_IO_LIS_LOG_TBL t    WHERE 1 = 1  
          order by t.insert_datetime asc

19.890s

SELECT/*+parallel(8) */ *   FROM SCM_IO_LIS_LOG_TBL t    WHERE 1 = 1  

          order by t.insert_datetime asc

19.987s

SELECT/*+parallel(16) */ *   FROM SCM_IO_LIS_LOG_TBL t    WHERE 1 = 1  
          order by t.insert_datetime asc

8.603s

SELECT/*+parallel(32) */ *   FROM SCM_IO_LIS_LOG_TBL t    WHERE 1 = 1  
          order by t.insert_datetime asc

6.661s