11G新特性，explain plan 可以评估出索引大小

最新推荐文章于 2021-11-26 20:39:18 发布

cotchte0421

最新推荐文章于 2021-11-26 20:39:18 发布

阅读量68

点赞数

ops$admin@CRMG>explain plan for
2 create index ttt on aaaa(id);

Explained.

ops$admin@CRMG>@display

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/22034023/viewspace-702021/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22034023/viewspace-702021/