On Tue, Feb 19, 2013 at 1:02 AM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:
Joe Van Dyk wrote:Currently WITH acts as an "optimization fence", that means
> My assumption was that WITH acted just like subselects, but apparently they don't? Using WITH doesn't
> use the expected index.
that means that the planner won't move conditions into or
out of the WITH query.
Where's the best place to read up on this?
Thanks,
Joe