Re: [ADMIN] Will an outer join on two indexed fields use the indexes?

2002-04-08 Thread Tom Lane
"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

[ADMIN] Will an outer join on two indexed fields use the indexes?

2002-04-08 Thread Nick Fankhauser
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