RE: 9.2.0.6 Optimizer issue

I am developing a new application and wanted to know if someone could refer me to document or web page that shows the proper method(s) of backing up statistics.

Thanks,
Ken

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling
Sent: Friday, May 06, 2005 10:52 AM
To: Ignizio, Richard
Cc: oracle-l_at_freelists.org
Subject: Re: 9.2.0.6 Optimizer issue

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

--
http://www.freelists.org/webpage/oracle-l