Re: 9.2.0.6 Optimizer issue
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: "Ignizio, Richard" <richard.ignizio@xxxxxxxxxx>
- Date: Fri, 06 May 2005 09:52:05 -0600
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
Other related posts:
