RE: Oracle Performance

  • From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 11 Mar 2004 13:47:16 -0600

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
-----------------------------------------------------------------

Other related posts: