| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl> |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] indexes |
| Date: | 1999-06-01 14:04:59 |
| Message-ID: | 21255.928245899@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl> writes:
> But without Vadim's suggestion I've got still similar results - sometimes
> optimizer has used index on e1 and on b1, sometimes on e1 and e2, but
> never on e1,b1 and e2 at once (note: this was join on ent e1, binds b1 and
> ent e2)
You won't ever see a three-way join in EXPLAIN's output, if that was
what you were looking for. Postgres always handles joins by combining
two tables, then combining the result with another table, etc.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-06-01 14:30:55 | Re: [SQL] Column name's length |
| Previous Message | Herouth Maoz | 1999-06-01 13:53:17 | Re: [SQL] 'denormalising' with a select |