"Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> monroe=# explain select * from
> monroe-#(charge left outer join criminal_disposition on
> monroe(# (charge.charge_id = criminal_disposition.charge_id));
> NOTICE: QUERY PLAN:
> Hash Join (cost=260.68..21110.40 rows=147101 width=3
Hi-
I've got another "plan" question- I'm trying to tune a query that uses an
outer join on two indexed (not unique) fields. I did an explain on it & was
surprised to find that the index wasn't used:
monroe=# explain select * from
monroe-#(charge left outer join criminal_disposition on
m