Tag Archives: STATMENT

语句级并行提示

最近才发现并行提示增加了语句级并行的功能。 以前添加并行都是对指定的表添加,最近才发现,如果不加表名,是指定这个语句的并行度: SQL> CREATE TABLE t_p_i AS 2 SELECT * 3 FROM dba_objects 4 WHERE 1 = 2; TABLE created. SQL> CREATE TABLE t_p_s AS 2 SELECT * 3 FROM dba_objects; TABLE created. SQL> SET autot ON EXP SQL> INSERT … Continue reading

Posted in ORACLE | Tagged , | Leave a comment