--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 2nd
"Domenic" <domenicg_at_hotmail.com> wrote in message
news:c7e08a19.0409171851.63f47d5a_at_posting.google.com...
> 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 Sat Sep 18 2004 - 01:05:31 CDT
