Re: statistics.
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 13 Jun 2008 08:09:38 GMT
Message-ID: <48522b42$0$30640$834e42db@reader.greatnowhere.com>
Date: 13 Jun 2008 08:09:38 GMT
Message-ID: <48522b42$0$30640$834e42db@reader.greatnowhere.com>
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 http://mgogala.freehostia.comReceived on Fri Jun 13 2008 - 03:09:38 CDT