KEEP INDEX | DROP INDEX
Specify KEEP INDEX or DROP INDEX to indicate
whether Oracle Database should preserve or drop the index it has been using to
enforce the PRIMARY KEY or UNIQUE constraint.[@more@]
whether Oracle Database should preserve or drop the index it has been using to
enforce the PRIMARY KEY or UNIQUE constraint.[@more@]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10599713/viewspace-1001508/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 關於rebuild index online 及drop index後重建問題RebuildIndex
- Drop table時候會徹底刪除index, Truncate 時候會清除index 但是index資料還是保留在HIndex
- ORA-02429: cannot drop index used for enforcement of unique/primary keyIndex
- rowid,index,INDEX FULL SCAN,INDEX FAST FULL SCAN|IndexAST
- 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
- 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
- 閃回之 回收站、Flashback Drop （table、index、trigger等）Index
- B-index、bitmap-index、text-index使用場景詳解Index
- Index Full Scan vs Index Fast Full ScanIndexAST
- Using index condition Using indexIndex
- 【Oracle】global index & local index的區別OracleIndex
- Index Full Scans和Index Fast Full ScansIndexAST
- What is meant by Primary Index and Secondary IndexIndex
- Index Full Scan 與 Index Fast Full ScanIndexAST
- PostgreSQL：INDEXSQLIndex
- <MYSQL Index>MySqlIndex
- jQuery index()jQueryIndex
- index索引Index索引
- rebuild indexRebuildIndex
- index rebuildIndexRebuild
- Bitmap IndexIndex
- index range scan,index fast full scan,index skip scan發生的條件IndexAST
- create index/create index online區別Index
- Create index with open on-line index creationIndex
- MYSQL中的type:index 和 Extra:Using indexMySqlIndex
- INDEX FULL SCAN和INDEX FAST FULL SCAN區別IndexAST
- index full scan 和 index FAST full scan 區別IndexAST
- oracle hint之hint_index_ffs,index_joinOracleIndex
- 【SQL 提示 之二】index_ss Index Skip HintSQLIndex
- create index , rebuild index troubleshooting 索引故障解決IndexRebuild索引
- Index Full Scan 與 Index Fast Full Scan (Final)IndexAST