Re: Function in WHERE performance issue

From: Rich Jesse <>
Date: Mon, 13 Jul 2009 09:11:05 -0500 (CDT)
Message-ID: <>

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.



Received on Mon Jul 13 2009 - 09:11:05 CDT

Original text of this message