statistics.

Hello

i am looking at V9 and try to figure out the equivalent command in oracle
of update statistics high for table mytable(mycolumn) in informix

this will command will produce a distribution of data and will help the optimizer
when there are a high number of certain values in column mycolumn to pick a
better query execution plan.

does oracle have such a beast; i found the 'analyze' button which does a dbms_stats.gather_table_stats looking in the help it said it would not look at the data...

what am i missing??

Thanks

Superboer. Received on Fri Jun 13 2008 - 01:50:00 CDT