Re: Function in WHERE performance issue

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-l


Other related posts: