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.
