Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: rm RULE based optimizer != GOOD IDEA

Re: rm RULE based optimizer != GOOD IDEA

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 22 Apr 2005 07:40:19 -0600
Message-ID: <4268FEC3.3050704@centrexcc.com>


It has already done so. The selectivity hint is gone in 10g. I would have preferred it over the cardinality hint - at least at times.

Post, Ethan wrote:
>
> What if Oracle decides to drop other hints for indexes, join types
> etc...?
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 22 2005 - 09:44:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US