diffrence between estimate statistics and compute statistics

[slimdave]

also, you should be using DBMS_STATS instead of the analyze command.

you can also get the option of sampling by % of rows or by % of blocks.