Re: Query capture
- From: stephen booth <stephenbooth.uk@xxxxxxxxx>
- To: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- Date: Thu, 7 Apr 2005 20:28:51 +0100
On Apr 7, 2005 8:06 PM, Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> 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
--
It's better to ask a silly question than to make a silly assumption.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
