Hi Guru's

I have a table with 10Million rows. I analyzed the same table using analyze table estimate statistics; after analyzing this table I found performance degrade.

Do I need to rebuild the indexes as well, along with analyze table? If I delete statistics, do I get the previous performance which is more better than after analyze? Please advice.

Please treat this an urgent.

I am using Oracle 8.1.7. Optimizer Mode CHOOSE. Block Size 4K

Regards