Create index with open on-line index creation
DB02>Configuration>On-line Index Creation
在生產庫上不開這個開關就建立索引是不可能的,大批使用者會因此而被鎖,現在SQL 2005支援線上索引的建立,這真是一個好功能.
SAP預設是關閉,當然建完後再關上就是,動態開關.
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/167898/viewspace-1028866/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- create index/create index online區別Index
- CREATE BITMAP INDEXIndex
- create index online 和create index 不同及注意點Index
- hive orc表'orc.create.index'='true'與'orc.create.index'='false'HiveIndexFalse
- create index , rebuild index troubleshooting 索引故障解決IndexRebuild索引
- create index .. onlineIndex
- Unable to create git index lockGitIndex
- create index onlineIndex
- Create Index ...ONLINEIndex
- create index online 與rebuild index onlineIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- CREATE INDEX index1 ON table1(col1)Index
- CREATE INDEX ......ONLINE分析Index
- postgresql create index concurrently過程描述SQLIndex
- MySQL online create index實現原理MySqlIndex
- Unable to create index.lock File exists錯誤Index
- 加快create / rebuild index的3個點(zt)RebuildIndex
- Default behavior of create & rebuild index in 10G (zt)RebuildIndex
- 加快建立索引(create / rebuild index) 的幾點索引RebuildIndex
- create index ORA-00376 處理方法Index
- 實踐001-elasticsearch的index、create、updateElasticsearchIndex
- KEEP INDEX | DROP INDEXIndex
- oracle10.2.0.4_create table_constraint_indexOracleAIIndex
- rowid,index,INDEX FULL SCAN,INDEX FAST FULL SCAN|IndexAST
- rebuild index online和create index online及沒有online的區別RebuildIndex
- INDEX UNIQUE SCAN,INDEX FULL SCAN和INDEX FAST FULL SCANIndexAST
- Clustered Index Scan and Clustered Index SeekIndex
- oracle hint之full,index,index_asc,index_desc,index_combile示例OracleIndex
- IndexIndex
- [Oracle] Create index速度測試nologging+parallelOracleIndexParallel
- create index logging, nologging performance testIndexORM
- create和recreate index時縮短時間的選項Index
- Index的掃描方式:index full scan/index fast full scanIndexAST
- rebuild index 和 recreate index (重新建立index) 的區別RebuildIndex
- pk 、unique index 和 index 區別Index
- global index & local index的區別Index
- alter index rebuild與index_statsIndexRebuild
- 【江楓 】Oracle 9i和10g在create index和rebuild index的統計資訊的區別OracleIndexRebuild