Hi
can some one please explain me that if i add a new index on a existing table and do not analyze the table then will oracle use that index properly or not in cost based optimizer.

The datatabase version is 7.3.4.4 .Please also tell me what will be the effect in 8i.

Ta
UKDBA