加快create / rebuild index的3個點(zt)
加快create / rebuild index的3個點
1。sort_area_size
增大sort_area_size,避免磁碟排序
對於auto pga的,應先設workarea_size_policy=manual後再設定sort_area_size
alter session set workarea_size_policy=manual
alter session set sort_area_size=512000000
2.加nologging引數
create index t on t(a) nologging
3.對於多CPU系統,可以加parallel 引數,通常為CPU數 or CPU數-1
create index t on t(a) nologging parallel 7
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-84343/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 加快建立索引(create / rebuild index) 的幾點索引RebuildIndex
- Default behavior of create & rebuild index in 10G (zt)RebuildIndex
- create index , rebuild index troubleshooting 索引故障解決IndexRebuild索引
- create index online 與rebuild index onlineIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- alter index ... rebuild online的機制(zt)IndexRebuild
- rebuild indexRebuildIndex
- index rebuildIndexRebuild
- create index online 和create index 不同及注意點Index
- Oracle create/rebuild index開並行時要記得noparallel哦~OracleRebuildIndex並行Parallel
- rebuild index 排序RebuildIndex排序
- sybase rebuild indexRebuildIndex
- ORACLE中index的rebuildOracleIndexRebuild
- rebuild index online和create index online及沒有online的區別RebuildIndex
- 【羅玄】從鎖的角度看rebuild index online和rebuild indexRebuildIndex
- Index rebuild --case 1IndexRebuild
- alter index rebuild 與 rebuild onlineIndexRebuild
- alter index rebuild與index_statsIndexRebuild
- 【江楓 】Oracle 9i和10g在create index和rebuild index的統計資訊的區別OracleIndexRebuild
- alter index rebuild和rebuild online的區別IndexRebuild
- rebuild index 和 recreate index (重新建立index) 的區別RebuildIndex
- create index/create index online區別Index
- Index Online RebuildIndexRebuild
- 索引是如何定期rebuild的(zt)索引Rebuild
- 聊聊索引Index Rebuild和Rebuild Online(下)索引IndexRebuild
- 聊聊索引Index Rebuild和Rebuild Online(上)索引IndexRebuild
- CREATE BITMAP INDEXIndex
- alter index ind1 rebuild 和alter index ind1 rebuild onlineIndexRebuild
- Oracle alter index rebuild 說明OracleIndexRebuild
- index rebuild online的問題IndexRebuild
- 大資料量rebuild index的經歷大資料RebuildIndex
- 如何加快建 index 索引 的時間Index索引
- hive orc表'orc.create.index'='true'與'orc.create.index'='false'HiveIndexFalse
- alter index rebuild online引發的血案IndexRebuild
- create index .. onlineIndex
- Unable to create git index lockGitIndex
- create index onlineIndex
- Create Index ...ONLINEIndex