I am working on Oracle 8.0.6 and the Init file has the Optimizer_mode set to = CHOOSE .
I did an estimate of statistics and the registration of the webiste became very slow .

It became fine when I gave the command " Analyze table tablename delete statistics"

I want to know under what conditions the analisation of tables can be disadvantageous .