Oracle Database Discussions

Hi,

I have one big table in Oracle10g. There was one month end job which is scaning whole table for update.
I created index on this table. But because of space issue we create this index 1 day before only.
After creating i issued

EXEC DBMS_STATS.gather_table_stats(USER, 'BIG_TABLE', cascade => TRUE, degree => 4);

but it was not picked up index.

While in Test Enviorment i used

Analyze table BIG_TABLE compute statistics

It picked up index and running fast

There is no difference in Test & production Enviornment.

Any one ever face such problem and what is the cause for this.

I need to submit RCA for this. If any one plz help

Thanks

Chetan