Reg Me Please <regmeple...@gmail.com> writes:
> 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))
If those rowcount estimates are accurate, then this is a perfectly good
plan; in fact probably the best you could hope for.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
