FOR ALL COLUMNS -- why??

Now that I'm looking at dbms_stats, what is the benefit of calculating histograms on columns that aren't indexed? Skew or no skew -- there is only one path.

So if I have a "gender" column and 95% are males and 5% are females, if it was indexed then this makes sense:

SELECT * FROM whatever WHERE gender = 'F' --> index scan SELECT * FROM whatever WHERE gender = 'M' --> full table scan

But if there's no index, what's the point?

Does anyone know of an example?

Domenic. Received on Fri Sep 17 2004 - 21:51:44 CDT