Re: Function in WHERE performance issue
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Mon, 13 Jul 2009 09:11:05 -0500 (CDT)
Message-ID: <e9b43343c437e32d44d9620d46c7682a.squirrel_at_society.servebeer.com>
Hey Jonathan,
Date: Mon, 13 Jul 2009 09:11:05 -0500 (CDT)
Message-ID: <e9b43343c437e32d44d9620d46c7682a.squirrel_at_society.servebeer.com>
Hey Jonathan,
> I think these two notes explain what's happening:
>
> Scalar subquery caching:
> http://jonathanlewis.wordpress.com/2006/11/06/filter-subqueries/
>
> Deterministic Functions: http://www.jlcomp.demon.co.uk/deterministic.html
>
After taking the weekend to *not* think about this issue, I'm not sure I follow you. Are you implying that the function in the WHERE clause acts like a subquery?
Also, since my query should return at most a single row (provided the data in the tables is correct) and I'm using 10.1.0.5.0, I wouldn't think that any deterministic caching would be taking place.
Thanks!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 13 2009 - 09:11:05 CDT