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@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 -- Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- //www.freelists.org/webpage/oracle-l