statistics.

#21

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

Quote:

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/B...ats.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...

#22

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

Quote:

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/B...ats.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...