| Impact of parallel index rebuild on partition index [message #625518] |
Thu, 09 October 2014 08:14  |
 |
archana_av
Messages: 1
Registered: October 2014
|
Junior Member |
|
|
I have query on impact of parallel clause in partition index rebuild . In case of non partitioned index what i come to know is ,Parallel index (re)build will persistently set the index parallel degree in data dictionary to the value used during build.This enables optimizer to consider parallel query plan for this object .Here is the DDL for non-partitioned index rebuild
alter index IX_RUN_ID rebuild parallel 4 nologging;
select degree from dba_indexes
where index_name ='IX_ALERT_CDR_RUN_ID'
output : 4
To change this ,alter index is required with no parallel clause
alter index IX_RUN_ID noparallel;
I would like to know the behavior of parallel clause in partition index rebuild , here is the DDL
alter index IX_AGG_VALUE rebuild partition P09 parallel 4 nologging;
After rebuilding all the index partition , i have checked dba_indexes for degree of parallelism and found its value as "1"
select degree from dba_indexes
where index_name ='IX_AGG_VALUE'
Pl clarify if there is different concept for normal index and partitioned index .
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
