Re: statistics.

From: Noons <>
Date: Fri, 13 Jun 2008 23:55:13 +1000
Message-ID: <g2tu7t$m9m$>

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