Reg Me Please wrote:
Here it comes:Aggregate (cost=227.59..227.61 rows=1 width=8) -> Nested Loop (cost=0.00..227.34 rows=49 width=8) -> Seq Scan on T2 (cost=0.00..1.07 rows=6 width=4) Filter: (fld1 = 'VEND'::text)-> Index Scan using i_T1_partial on T1 (cost=0.00..37.61 rows=8 width=8)Index Cond: ((T1.prod_id = 42) AND (T1.fk1 = T2.fk1))
That's the EXPLAIN output, _not_ EXPLAIN ANALYZE as requested. Probably statistics aren't up-to-date? Thomas -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
