"Alter index rebuild online parallel n"會修改索引的degree屬性
"Alter index rebuild online parallel n"會將索引的degree屬性修改為n，這樣可能會造成與該索引相關的執行計劃改變，可能對生產系統產生影響，因此在開併發對索引進行重構之後應該使用以下SQL將索引的degree屬性置為原來的值(例如：1)：
Alter index_name parallel 1;
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11411056/viewspace-733800/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- alter index rebuild 與 rebuild onlineIndexRebuild
- alter index rebuild和rebuild online的區別IndexRebuild
- alter index ind1 rebuild 和alter index ind1 rebuild onlineIndexRebuild
- alter index rebuild online引發的血案IndexRebuild
- alter index ... rebuild online的機制(zt)IndexRebuild
- oracle10g_alter index rebuild_online_重構索引OracleIndexRebuild索引
- 聊聊索引Index Rebuild和Rebuild Online（下）索引IndexRebuild
- 聊聊索引Index Rebuild和Rebuild Online（上）索引IndexRebuild
- alter index rebuild與index_statsIndexRebuild
- Index Online RebuildIndexRebuild
- Oracle alter index rebuild 說明OracleIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- index rebuild online的問題IndexRebuild
- 【羅玄】從鎖的角度看rebuild index online和rebuild indexRebuildIndex
- 重建索引index rebuild online vs offline vs index coalesce vs index shrik space索引IndexRebuild
- 索引rebuild和rebuild online時要慎重索引Rebuild
- rebuild index online和create index online及沒有online的區別RebuildIndex
- PARALLEL_DEGREE_POLICParallel
- 索引rebuild和rebuild online時要慎重(轉載）索引Rebuild
- rebuild index online的鎖機制淺析RebuildIndex
- 利用 alter 語句修改欄位屬性
- create index , rebuild index troubleshooting 索引故障解決IndexRebuild索引
- 測試index online rebuild故障記錄IndexRebuild
- “rebuild index online hang住" 問題解析RebuildIndex
- 加快建立索引（create / rebuild index） 的幾點索引RebuildIndex
- 關於rebuild index online 及drop index後重建問題RebuildIndex
- alter table nologging /*+APPEND PARALLEL(n)*/APPParallel
- Online rebuild index遭遇ORA-08104RebuildIndex
- rebuild online索引遇到ora-1450Rebuild索引
- ORA-08104 索引online rebuild索引Rebuild
- 索引rebuild online失敗後處理索引Rebuild
- rebuild indexRebuildIndex
- index rebuildIndexRebuild
- （轉）Index Rebuild Online 過程(9i)完整版IndexRebuild
- rebuild index 排序RebuildIndex排序
- sybase rebuild indexRebuildIndex
- ORACLE中index的rebuildOracleIndexRebuild