Delete indexes to free database.
Transaction: SE11, DB02
用DB02根據Index Usage(DB02>Performance>Indexes>Index Usage),篩選出一些User seeks為0的使用者自定義的Index,用SE11一一刪除,節省出50GB空間.
下一步驟是挑一個空閒日,shrink database 或 shrink datafiles.
等來年空間緊張時,再來得篩選沒人用的SAP的Index.
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/167898/viewspace-1028750/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- C malloc() free(), C++ new() delete()C++delete
- 翻譯(九)——Clustered Indexes: Stairway to SQL Server Indexes Level 3IndexAISQLServer
- Error querying database. XXXXXXXXXXXXX, No database selected。ErrorDatabase
- [20180510]20 Indexes.txtIndex
- PostgreSQL DBA(45) - Hypothetical Indexes in PostgreSQLSQLIndex
- MySQL 8 新特性之Invisible IndexesMySqlIndex
- free命令
- JavaScript deleteJavaScriptdelete
- URLSearchParams delete()delete
- FormData delete()ORMdelete
- [20202117]Function based indexes and cursor sharing.txtFunctionIndex
- [20220414]Function based indexes and cursor sharing2.txtFunctionIndex
- Map delete() 方法delete
- WeakMap delete() 方法delete
- WeakSet delete() 方法delete
- SQL__DELETESQLdelete
- Set delete() 方法delete
- JavaScript delete用法JavaScriptdelete
- URLSearchParams delete() 方法delete
- git delete and revertGitdelete
- MySQL Delete PHPMySqldeletePHP
- Oracle Free Buffer WaitsOracleAI
- [LeetCode] Employee Free TimeLeetCode
- PostgreSQL DBA(159) - pgAdmin(Allow vacuum command to process indexes in paralleSQLIndex
- OUTLOOK - Unable to Delete Meetingsdelete
- 740. Delete and Earndelete
- 聊聊dba_temp_free_space的allocated_space和free_space
- Latch free等待事件(轉)事件
- [轉帖]剖析free命令
- Use-After-Free漏洞
- Oracle 19c Concepts(03):Indexes and Index-Organized TablesOracleIndexZed
- Oracle 19C 無法啟用Auto Indexes特性OracleIndex
- cmu15545筆記-索引併發控制(Concurrent Indexes)筆記索引Index
- 450-Delete Node in a BSTdelete
- 記憶體(new delete )記憶體delete
- Sanic delete()方法/函式delete函式
- 如何提高MySQL DELETE 速度MySqldelete
- jemalloc delete 出現 segmentfaultdelete
- 新功能初探 | MySQL 8.0 Multi-Valued Indexes功能簡述MySqlIndex