Issues needing attention in Oracle's use of parallel indexing

When the structure of the index. We're going to build the index fast. It will be added parallel, plus parallel. This will parallel the column index.

When the degree of parallelism index is accessed, the CBO you may consider running in parallel, which may cause some problems. Being in parallel with the server can cause more serious contention. When you use parallel. Need to change the degree of parallelism back.

sql> drop table test purge;

sql> CREATE TABLE test as SELECT * from Dba_objects;
Sql> CREATE index ind_t_object_id on test (object_id) parallel 4;
Sql> Select S.degree
From Dba_indexes S
where s.index_name = Upper (' ind_t_object_id ');
Degree
----------------------------------------
4

sql> alter index ind_t_object_id Noparallel;

Sql> Select S.degree
From Dba_indexes S
where s.index_name = Upper (' ind_t_object_id ');
Degree
----------------------------------------
1

Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.

Issues needing attention in Oracle's use of parallel indexing