| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Fabrizio Mazzoni" <fabrizio(at)macron(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: I: Help with indexes/queries/msaccess |
| Date: | 2001-06-29 14:44:52 |
| Message-ID: | 7279.993825892@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Fabrizio Mazzoni" <fabrizio(at)macron(dot)com> writes:
> The following query, when launched on postgres with the
> explain command, isn't using index scans but only sequential scans..why is
> this?
Have you done VACUUM ANALYZE?
> I was thinking of rewriting it with the "classic" join syntax eg: select *
> from a,b where a.a=b.b ...would this partially solve my problem??
If you actually need the outer-join behavior then you can't do that.
However, it might help to rearrange the order in which the joins are
done. See
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/explicit-joins.html
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wsheldah | 2001-06-29 14:50:17 | Re: I: Help with indexes/queries/msaccess |
| Previous Message | Thalis A. Kalfigopoulos | 2001-06-29 14:29:31 | Re: Trigger |