Date: Thu, 12 Jun 2008 23:50:00 -0700 (PDT)
i am looking at V9 and try to figure out the equivalent command in
of update statistics high for table mytable(mycolumn) in informix
this will command will produce a distribution of data and will help
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??
Superboer. Received on Fri Jun 13 2008 - 01:50:00 CDT