Re: statistics.

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Fri, 13 Jun 2008 23:55:13 +1000
Message-ID: <g2tu7t$m9m$1@registered.motzarella.org>


Superboer wrote,on my timestamp of 13/06/2008 4:50 PM:

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

you're missing this:
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_stats.htm#999107 if it asks you for a login, follow the links to create one: you won't be spammed (much...).

read all about collecting stats, histograms (similar to what you're after) and all other sorts of goodies.

And like Mladen said: it must read data to collect stats.

I'll just add: don't forget there are lies, damn lies and statistics... Received on Fri Jun 13 2008 - 08:55:13 CDT

Original text of this message