oracle 创建索引开并行,oracle的并行功能，本例只是索引的建立

QL> set timing on;

SQL> create index inv_date_no on inv_transactions_log_bk(date_no);

Index created

Executed in 274.047 seconds

SQL> drop index INV_DATE_NO;

Index dropped

Executed in 0.047 seconds

SQL> create index inv_date_no on inv_transactions_log_bk(date_no) nologging;

Index created

Executed in 189.875 seconds

SQL> drop index INV_DATE_NO;

Index dropped

Executed in 0.047 seconds

SQL> create index inv_date_no on inv_transactions_log_bk(date_no) parallel 3 nologging;

Index created

Executed in 334.906 seconds

[@more@]

create index ind_name on table_name(column) parallel degree;

PARALLEL_MAX_SERVERS specifies the maximum number of parallel execution processes and parallel recovery processes for an instance.

SQL> show parameter PARALLEL_MAX_SERVERS;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

parallel_max_servers integer 5