Update Global Indexes with Parallel Clause.
Hi all!
I came across in a manual about this.But still have some doubt regarding the clause Parallel 5 degree used with UPDATE GLOBAL INDEXES.
Could anybody explain the significance of it.
ALTER TABLE SALES
EXCHANGE PARTITION SALES_Q1_2000
TABLE SALES_2000
UPDATE GLOBAL INDEXES
PARALLEL(DEGREE 4);
What would be the state of Local as well as Global Indexes in terms of USABLE,UNUSABLE status:
a).Will the local indexes be in a usable state but global indexes in unusable state.
b).Will the local indexes be in a usable state but global indexes in unusable state considering PARALLEL(DEGREE 4)
is maintained.
c)..Will the local indexes be in a usable state but global indexes in unusable state considering PARALLEL(DEGREE 4)
is not maintained.
Thanks & Regards,
Amit.