Sorry if I'm off-base, but is this a language misunderstanding problem? I think that "the rule is under the same conditions, Oracle is always faster, so..." means: "If an Oracle-based application is slower than the same application on a competing database, then there's probably something that a smart person can do to make the Oracle one perform much faster." I don't think it intended was a statement about whether RULE or CHOOSE is better. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 3/23 Park City, 4/6 Seattle - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Juan Cachito Reyes Pacheco Sent: Thursday, March 11, 2004 10:19 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Oracle Performance Why you changed what I said. I said Honestly I don't agree with this, I don't think there is any need to use rule, in Oracle 9i, CBO works perfectly with this kind of situation, the problem must be find and fixed. ----- Original Message ----- From: "Bricklen Anderson" <BAnderson@xxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Thursday, March 11, 2004 11:01 AM Subject: Re: Oracle Performance > Juan Cachito Reyes Pacheco wrote: > <snip> > > The rule is under same conditions Oracle is always faster, so I think you > > are doing > > something wrong, if you want to get some help you will have to post more > > information. > <snip> > Really? That's an interesting rule. Any metrics to support that > statement, or does that kinda fall into the same category as the other > 'myths'? > > > Regards, > > Bricklen > > -- > Bricklen Anderson, Database Administrator > PresiNET Systems > http://www.PresiNET.com > Online Demo: https://www.presinet.com/secure/login > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------