Victor Muntes Mutero <[EMAIL PROTECTED]> writes:
> There is an xjoin (p_partkey = l_partkey)
Not in that form of the query. You have
WHERE ( ... ) OR ( ... ) OR ( ... )
If Postgres were to reduce the WHERE expression to CNF, it would discover
that the p_partkey = l_partkey clause is co
From: "Victor Muntes Mutero" <[EMAIL PROTECTED]>
> We have Postgres 7.0.2 .
>
> There is a query in TPC-H Benchmark that produces this execution plan:
>
> Aggregate (cost=698221486855.00..698221486855.00 rows=1 width=72)
> -> Nested Loop (cost=0.00..698221486855.00 rows=1 width=72)
>
