11G新特性,explain plan 可以評估出索引大小
plan for
2 create index ttt on aaaa(id);
Explained.
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 2861610204
-------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------
| 0 | CREATE INDEX STATEMENT | | 409 | 5317 | 4 (0)| 00:00:01 |
| 1 | INDEX BUILD NON UNIQUE| TTT | | | | |
| 2 | SORT CREATE INDEX | | 409 | 5317 | | |
| 3 | TABLE ACCESS FULL | AAAA | 409 | 5317 | 3 (0)| 00:00:01 |
-------------------------------------------------------------------------------
Note
-----
- estimated index size: 65536 bytes
14 rows selected.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31397003/viewspace-2134890/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11g 新特性 -- SQL Plan Management 示例OracleSQL
- Explain PlanAI
- 11g新特性:不可視索引索引
- explain plan VS execution planAI
- USE EXPLAIN PLANAI
- 11G 新特性:密碼大小寫策略密碼
- Oracle 11g SQL效能的新特性(三)- SQL Plan ManagementOracleSQL
- Oracle EXPLAIN PLAN用法OracleAI
- Explain for the Statistics of Execution PlanAI
- explain plan 的用法AI
- oracle 11g新特性之密碼大小寫敏感Oracle密碼
- oracle explain plan for的用法OracleAI
- expdp在匯出時對資料大小進行評估
- 11g新特性: 索引不可見(Index Invisible)索引Index
- 【DBA】Oracle 11g 針對SQL效能的新特性(三)- SQL Plan ManagementOracleSQL
- ORACLE EXPLAIN PLAN的總結OracleAI
- Use the statspack to generate the accurate explain planAI
- explain plan 學習記錄AI
- Error: cannot fetch last explain plan from PLAN_TABLEErrorASTAI
- 【ORACLE新特性】11G 分割槽新特性Oracle
- Using Statspack to Record Explain Plan DetailsAI
- 用EXPLAIN PLAN 分析SQL語句AISQL
- MySQL 索引 +explainMySql索引AI
- mysql explain預估剖析MySqlAI
- 【Explain Plan】10g中的PLAN_TABLE$臨時表AI
- Oracle 11g 新特性Oracle
- 【執行計劃】格式化EXPLAIN PLAN的輸出結果AI
- 8.0新特性-不可見索引索引
- 【新特性速遞】評分,評分,評分
- Oracle執行計劃Explain Plan 如何使用OracleAI
- oracle 使用explain plan分析查詢語句OracleAI
- EXPLAIN PLAN and SQL*PLUS AUTOTRACE may not generate actual plansAISQL
- toad顯示explain plan的問題AI
- Oracle 執行計劃(Explain Plan) 說明OracleAI
- autotrace explain plan 相關引數解釋AI
- Oracle 執行計劃(Explain Plan) 說明OracleAI
- 11g data guard 新特性
- 11g新特性--active dataguard