Re: RE: query slow in 9i, but not slow in 8i

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Mon, 01 Mar 2004 18:04:24 -0700
Message-Id: <6.0.0.22.2.20040301175705.03035c88@pop.centrexcc.com>

As long as it works for you - nothing.

However - to quote myself:
"Histograms are like drugs – An overdose [of histograms] can kill [performance]."

And like drugs, the practice may seem harmless and you get used to it, until one day ...

"It seems easier just to ..." is never a good enough reason for me to do - or not do - something.

At 04:14 PM 3/1/2004, you wrote:
>If you have the window and use monitoring what is wrong with getting
>histograms on every table? I'm doing all new development with new queries
>getting developed everyday. It seems easier just to put histograms on
>everything. I have the window to do this overnight and will have it when we
>go live?

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
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 Mon Mar 01 2004 - 18:59:02 CST