Sean Shanny <[EMAIL PROTECTED]> writes:
>> I think the problem is not there at all, but with drastic
>> underestimation of the number of rows coming from f_pageviews:
> It does not make sense that the smaller set of values in the IN clause
> would work then does it?
Look at your two plans. In o
Tom,
It does not make sense that the smaller set of values in the IN clause
would work then does it?
We took a look at the code we compiled from and indeed the patch you
provided was not not applied, out fault. The patch is in the 7.4.2
code base. We upgraded today and I will be running th
Sean Shanny <[EMAIL PROTECTED]> writes:
> When I run this against our warehouse instance I get an out of memory
> error. If I remove the
> AND t1.newsletterid_key IN (SELECT newsletterid FROM t_newscontentstatic)
> portion if runs fine.
I think the problem is not there at all, but with drastic
u