Date: Fri, 13 Jun 2008 23:55:13 +1000
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