Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: query slow in 9i, but not slow in 8i
At 07:51 AM 3/2/2004, you wrote:
>My personal preference is 'FOR ALL INDEXED COLUMNS', because I don't see
>histograms making sense for non-indexed columns.
Oh, yes they can. Can make a lot of sense and a big difference. And there are many indexed columns (single-column prime or unique keys just for starters) where they make absolutely no sense.
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Mar 02 2004 - 09:00:44 CST
![]() |
![]() |