From: Superboer <>
Date: Thu, 12 Jun 2008 23:50:00 -0700 (PDT)
Message-ID: <>


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??


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

Original text of this message