Re: Query capture

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 07 Apr 2005 14:33:43 -0600
Message-ID: <42559927.2050706@centrexcc.com>

Stephen,

The "you" wasn't meant personal. I know that you just wrote a quick sql in response to the question on Oracle-L. I just wanted to point out an all-to-easy made mistake.

stephen booth wrote:

> On Apr 7, 2005 8:06 PM, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
>

>>The old problem. You are relying on a specific order of execution of the
>>predicates. Oracle is perfectly in its right to calculate
>>(a.elapsed_time/(1000000*a.executions)) > 5
>>before
>>a.executions > 0

>
>
> Actually it was just a case that it worked when I tried it and so it
> didn't occur to me that another Oracle instance might evaluate the
> where clause in a different order. Oh well, we live and learn.
>
> Stephen

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 07 2005 - 18:44:33 CDT