RE: Oracle Performance

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Thu, 11 Mar 2004 13:47:16 -0600
Message-ID: <017a01c407a1$b0a3cb30$8b00470a@CVMLAP02>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Cachito Reyes Pacheco
Sent: Thursday, March 11, 2004 10:19 AM
To: oracle-l_at_freelists.org
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_at_PresiNET.com> To: <oracle-l_at_freelists.org> 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Mar 11 2004 - 15:16:17 CST