Re: Function in WHERE performance issue

  • From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
  • To: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 13 Jul 2009 09:11:05 -0500 (CDT)

Hey Jonathan,

> I think these two notes explain what's happening:
> Scalar subquery caching:
> Deterministic Functions:

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, I wouldn't think that
any deterministic caching would be taking place.




Other related posts: