"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
Bob-
I'm pasting in a chunk from some of my local documentation for our system.
In our case, we don't touch the default, but rather set up some new
locations, but you may want to do something similar, and the description of
the process may help if you still want to change the default location. Th