Oracle中检查是否需要重构索引
Oracle中检查是否需要重构索引 SELECT height, /*Height of the B-Tree*/ blocks, /* Blocks in the index segment */ na
Oracle中检查是否需要重构索引
SELECT
height, /*Height of the B-Tree*/
blocks, /* Blocks in the index segment */
name, /*index name */
lf_rows, /* number of leaf rows in the index */
lf_blks, /* number of leaf blocks in the index */
del_lf_rows, /* number of deleted leaf rows in the index */
rows_per_key /* average number of rows per distinct key */
blk_gets_per_access /* consistent mode block reads (gets) */
FROM INDEX_STATS
WHERE;
SELECT
height, /*Height of the B-Tree*/
blocks, /* Blocks in the index segment */
name, /*index name */
lf_rows, /* number of leaf rows in the index */
lf_blks, /* number of leaf blocks in the index */
del_lf_rows, /* number of deleted leaf rows in the index */
rows_per_key /* average number of rows per distinct key */
blk_gets_per_access /* consistent mode block reads (gets) */
FROM INDEX_STATS
WHERE;[sql] view plaincopyprint?
ANALYZE index INDEX_NAME VALIDATE STRUCTURE
ANALYZE index INDEX_NAME VALIDATE STRUCTUREHEIGHT:
This column refers to the height of the B-tree index, and it’s usually at the 1, 2, or 3 level.
If large inserts push the index height beyond a level of 4, it’s time to rebuild, which flattens the B-tree.
DEL_LF_ROWS:
This is the number of leaf nodes deleted due to the deletion of rows.
Oracle doesn’t rebuild indexes automatically and, consequently, too many deleted leaf rows can lead to an unbalanced B-tree.
BLK_GETS_PER_ACCESS:
You can look at the BLK_GETS_PER_ACCESS column to see how much logical I/O it takes to retrieve data from the index. If this row shows a double-digit number, you should probably start rebuilding the index.
上一篇: Centos7架设NMP服务器笔记
下一篇: MySQL 排序的详细介绍
推荐阅读
-
php-Arrays函数-array_key_exists-检查给定的键名或索引是否存在于数组中_PHP教程
-
PHP array_key_exists检查键名或索引是否存在于数组中的实现方法_php实例
-
Oracle中检查是否需要重构索引的sql
-
Oracle中检查外键是否有索引的SQL脚本分享
-
Oracle中检查是否需要重构索引的sql
-
Oracle外键列上是否需要索引?
-
PHP array_key_exists检查键名或索引是否存在于数组中的实现方法,arraykeyexists_PHP教程
-
PHP array_key_exists检查键名或索引是否存在于数组中的实现方法,arraykeyexists
-
PHP array_key_exists检查键名或索引是否存在于数组中的实现方法_php实例
-
Oracle中检查外键是否有索引的SQL脚本分享