connect internal
spool viw1.log
validate index VCIN.CJIS_MNE_LKUP_INDEX;
select '#VCIN.'||name, LF_ROWS_LEN, DEL_LF_ROWS_LEN, (DEL_LF_ROWS_LEN*100) / (LF_ROWS_LEN+DEL_LF_ROWS_LEN+1) from index_stats;
validate index VCIN.EVT_REGISTRY_CONSTRAINT;
select '#VCIN.'||name, LF_ROWS_LEN, DEL_LF_ROWS_LEN, (DEL_LF_ROWS_LEN*100) / (LF_ROWS_LEN+DEL_LF_ROWS_LEN+1) from index_stats;
validate index VCIN.FK_MNU_FCN_IDX;
select '#VCIN.'||name, LF_ROWS_LEN, DEL_LF_ROWS_LEN, (DEL_LF_ROWS_LEN*100) / (LF_ROWS_LEN+DEL_LF_ROWS_LEN+1) from index_stats;
validate index VCIN.FK_MNU_HIST_FCN_IDX;
select '#VCIN.'||name, LF_ROWS_LEN, DEL_LF_ROWS_LEN, (DEL_LF_ROWS_LEN*100) / (LF_ROWS_LEN+DEL_LF_ROWS_LEN+1) from index_stats;
validate index VCIN.FK_MONIKER_FCN_IDX;
select '#VCIN.'||name, LF_ROWS_LEN, DEL_LF_ROWS_LEN, (DEL_LF_ROWS_LEN*100) / (LF_ROWS_LEN+DEL_LF_ROWS_LEN+1) from index_stats;
validate index VCIN.FK_MONIKER_HIST_FCN_IDX;
select '#VCIN.'||name, LF_ROWS_LEN, DEL_LF_ROWS_LEN, (DEL_LF_ROWS_LEN*100) / (LF_ROWS_LEN+DEL_LF_ROWS_LEN+1) from index_stats;
.
.
.