Rebuild Required Myth

Posted: June 14, 2013 in Notes, Oracle
create table test_ind_del as select rownum id from dual connect by rownum<10
select * from test_ind_del
create index test_ind_del_idx on test_ind_del(id)
analyze index test_ind_del_idx validate structure
select name,lf_rows, del_lf_rows from index_stats
--1	TEST_IND_DEL_IDX	9	0
delete from test_ind_del where id in (2,4,6,8)
analyze index test_ind_del_idx validate structure
select name,lf_rows, del_lf_rows from index_stats
--1	TEST_IND_DEL_IDX	9	4
insert into test_ind_del values(2);
analyze index test_ind_del_idx validate structure
select name,lf_rows, del_lf_rows from index_stats
--1	TEST_IND_DEL_IDX	6	0

Great Richard Foot’s note

http://richardfoote.wordpress.com/2011/05/22/del_lf_rows-index-rebuild-criteria-codex/

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s