Re: 9.2.0.6 Optimizer issue

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 06 May 2005 09:52:05 -0600
Message-ID: <427B92A5.2080104@centrexcc.com>

responses inline

Ignizio, Richard wrote:

> As of right now I do not back up old statistics, but I might make it a practice now.

DO, not might

> The database was shutdown before the application upgrade for backups, would that erase the contents of the sys.col_usage$ table?

Not normally

> Would histograms affect whether Oracle chose to do a NL or a HJ?

Histograms can affect not only the choice of join method but other plan particulars as well. So can any number of statistics.

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 06 2005 - 11:56:33 CDT