hi aji,

I have nt Analyzed the index after recreating it,but anyway i will do so using

Analyze Index <Indx name>Compute statistics;

Can u tell me what is the next step..of it.I know that this above statment will put some of the statistics in dba_indexes.Can u please tell me how to find out whether the index is ok or not.if it is not ok,then what should i do to solve it.

Thanks,
Vinod.