index與nologging
在create index ... nologging 和 alter index ... rebuild nologging時,nologging會生效。
在後續DML操作時,會生成redo log。雖然index設定為nologging
在臨時表上的索引也是一樣會產生undo。
select tablespace_name,
status,
trunc(sum(blocks) * 8 / 1024) as size_m,
count(*) undo_extent_num
from dba_undo_extents
group by tablespace_name, status
order by 1;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/720091/viewspace-1135588/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [Oracle] Create index速度測試nologging+parallelOracleIndexParallel
- create index logging, nologging performance testIndexORM
- oracle 構建索引index_logging_nologgingOracle索引Index
- nologging與append ztAPP
- alter index rebuild與index_statsIndexRebuild
- null與indexNullIndex
- Index Full Scan 與 Index Fast Full ScanIndexAST
- 轉eygle_append與nologgingAPP
- Index Full Scan 與 Index Fast Full Scan (Final)IndexAST
- nologging選項的學習與測試
- oracle invisible index與unusable index的區別OracleIndex
- create index online 與rebuild index onlineIndexRebuild
- alter index compute statistics與analyze index的比較Index
- create index online 與rebuild index onlineIndexRebuild
- 高效的SQL(index values與index column values關係?)SQLIndex
- Elasticsearch之索引模板index template與索引別名index aliasElasticsearch索引Index
- oracle dml與索引index(一)Oracle索引Index
- Oracle nologgingOracle
- Oracle DML NOLOGGINGOracle
- Oracle’s NOLOGGINGOracle
- hive orc表'orc.create.index'='true'與'orc.create.index'='false'HiveIndexFalse
- 唯一性索引(Unique Index)與普通索引(Normal Index)差異(上)索引IndexORM
- 唯一性索引(Unique Index)與普通索引(Normal Index)差異(中)索引IndexORM
- 唯一性索引(Unique Index)與普通索引(Normal Index)差異(下)索引IndexORM
- 【INDEX】使用“alter index ××× monitoring usage;”語句監控索引使用與否Index索引
- Index Range Scan成本與10053Index
- alter index rebuild 與 rebuild onlineIndexRebuild
- unique index與primary key的區別Index
- Nologging and append testAPP
- oracle啟用nologgingOracle
- KEEP INDEX | DROP INDEXIndex
- oracle support nologging ddl dmlOracle
- oracle nologging和appendOracleAPP
- NOLOGGING 應用場景
- rowid,index,INDEX FULL SCAN,INDEX FAST FULL SCAN|IndexAST
- MySQL explain結果Extra中"Using Index"與"Using where; Using index"區別MySqlAIIndex
- Oracle的Nologging何時生效 與 批次insert載入資料效率.Oracle
- INDEX UNIQUE SCAN,INDEX FULL SCAN和INDEX FAST FULL SCANIndexAST