Brian Herlihy <[EMAIL PROTECTED]> writes:
> The issue: the second query results in a lower cost estimate. I am wondering
> why the second query plan was not chosen for the first query.
8.1 is incapable of pushing indexable join conditions down below an Append.
Try 8.2.
r
"Brian Herlihy" <[EMAIL PROTECTED]> writes:
> There is a unique index mapping domains to domain_ids.
...
> The issue: the second query results in a lower cost estimate. I am wondering
> why the second query plan was not chosen for the first query.
Well the unique index you mentioned is critical t
