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.

On Thu, 12 Jun 2008 23:50:00 -0700, Superboer wrote:

Oracle can't collect statistics without looking at the data. DBMS_STATS
is used to collect the optimizer statistics. It has many options and
possibilities, in fact, it is a small science. Jonathan Lewis wrote a 500+
pages book devoted mostly to the stuff related to DBMS_STATS.

--
Mladen Gogala
http://mgogala.freehostia.com

On Thu, 12 Jun 2008 23:50:00 -0700, Superboer wrote:

Oracle can't collect statistics without looking at the data. DBMS_STATS
is used to collect the optimizer statistics. It has many options and
possibilities, in fact, it is a small science. Jonathan Lewis wrote a 500+
pages book devoted mostly to the stuff related to DBMS_STATS.

--
Mladen Gogala
http://mgogala.freehostia.com

On Thu, 12 Jun 2008 23:50:00 -0700, Superboer wrote:

Oracle can't collect statistics without looking at the data. DBMS_STATS
is used to collect the optimizer statistics. It has many options and
possibilities, in fact, it is a small science. Jonathan Lewis wrote a 500+
pages book devoted mostly to the stuff related to DBMS_STATS.

--
Mladen Gogala
http://mgogala.freehostia.com

On Thu, 12 Jun 2008 23:50:00 -0700, Superboer wrote:

Oracle can't collect statistics without looking at the data. DBMS_STATS
is used to collect the optimizer statistics. It has many options and
possibilities, in fact, it is a small science. Jonathan Lewis wrote a 500+
pages book devoted mostly to the stuff related to DBMS_STATS.

--
Mladen Gogala
http://mgogala.freehostia.com

On Thu, 12 Jun 2008 23:50:00 -0700, Superboer wrote:

Oracle can't collect statistics without looking at the data. DBMS_STATS
is used to collect the optimizer statistics. It has many options and
possibilities, in fact, it is a small science. Jonathan Lewis wrote a 500+
pages book devoted mostly to the stuff related to DBMS_STATS.

--
Mladen Gogala
http://mgogala.freehostia.com

On Thu, 12 Jun 2008 23:50:00 -0700, Superboer wrote:

Oracle can't collect statistics without looking at the data. DBMS_STATS
is used to collect the optimizer statistics. It has many options and
possibilities, in fact, it is a small science. Jonathan Lewis wrote a 500+
pages book devoted mostly to the stuff related to DBMS_STATS.

--
Mladen Gogala
http://mgogala.freehostia.com

On Thu, 12 Jun 2008 23:50:00 -0700, Superboer wrote:

Oracle can't collect statistics without looking at the data. DBMS_STATS
is used to collect the optimizer statistics. It has many options and
possibilities, in fact, it is a small science. Jonathan Lewis wrote a 500+
pages book devoted mostly to the stuff related to DBMS_STATS.

--
Mladen Gogala
http://mgogala.freehostia.com

On Jun 13, 4:09*am, Mladen Gogala <mgog... (AT) yahoo (DOT) com> wrote:
Superboer, I believe the specific statistics related feature you are
asking about is histograms. As Mlladen identified the dbms_stats
package will generate statistics including histograms if desired. See
the Supplied Packages and Types manual for a write up on dbms_stats
and its options.

HTH -- Mark D Powell --

On Jun 13, 4:09*am, Mladen Gogala <mgog... (AT) yahoo (DOT) com> wrote:
Superboer, I believe the specific statistics related feature you are
asking about is histograms. As Mlladen identified the dbms_stats
package will generate statistics including histograms if desired. See
the Supplied Packages and Types manual for a write up on dbms_stats
and its options.

HTH -- Mark D Powell --