Re: statistics.

From: Mladen Gogala <>
Date: 13 Jun 2008 08:09:38 GMT
Message-ID: <48522b42$0$30640$>

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

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

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
Received on Fri Jun 13 2008 - 03:09:38 CDT

Original text of this message