//index info
select i.index_name,
i.distinct_keys, i.num_rows
from user_indexes i, user_ind_columns c
where i.index_name = c.index_name
and c.table_name = upper('reps_sla_item')
//rebuild index
alter index sys_c0066955 rebuild
//analyze table
analyze table reps_sla_item estimate statistics sample 30 percent;
select i.index_name,
i.distinct_keys, i.num_rows
from user_indexes i, user_ind_columns c
where i.index_name = c.index_name
and c.table_name = upper('reps_sla_item')
//rebuild index
alter index sys_c0066955 rebuild
//analyze table
analyze table reps_sla_item estimate statistics sample 30 percent;