RE: 9.2.0.6 Optimizer issue
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <breitliw@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 May 2005 16:58:07 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Wolfgang Breitling
Sent: Friday, May 06, 2005 10:52 AM
To: Ignizio, Richard
Cc: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
