Index rebuild/Benefit -- Scripts to find the Fragmented indexes
Hello All,
I was working on the index rebuild stuff and not able to come to conclusion that the below script is really applicable in all the cases. Could anyone of you please review the below script and comment on it?
set lines 500
col NEW_IDX_percentage 999.99999
col idxname format a38 head "Owner.Index"
col uniq format a01 head "U"
col tsname format a28 head "Tablespace"
col xtrblk format 999999 head "Extra|Blocks"
col lfcnt format 9999999 head "Leaf|Blocks"
col blk format 9999999 head "Curr|Blocks"
col currmb format 99999 head "Curr|MB"
col newmb format 99999 head "New|MB"
select
u.name ||'.'|| o.name idxname,
I was working on the index rebuild stuff and not able to come to conclusion that the below script is really applicable in all the cases. Could anyone of you please review the below script and comment on it?
set lines 500
col NEW_IDX_percentage 999.99999
col idxname format a38 head "Owner.Index"
col uniq format a01 head "U"
col tsname format a28 head "Tablespace"
col xtrblk format 999999 head "Extra|Blocks"
col lfcnt format 9999999 head "Leaf|Blocks"
col blk format 9999999 head "Curr|Blocks"
col currmb format 99999 head "Curr|MB"
col newmb format 99999 head "New|MB"
select
u.name ||'.'|| o.name idxname,
5