| From: | Jeff Boes <jboes(at)qtm(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Join efficiency |
| Date: | 2004-09-02 14:21:07 |
| Message-ID: | o%FZc.92610$JG7.56336@hydra.nntpserver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Russ Brown wrote:
> Is there any difference between these queries in terms of the speed of
> planning or the quality of the plan untimately used? I'd imagine that
> the second form provides more information that the planner may be able
> to use to make a better plan (or make a good plan more easily), but
> I've never had any problems with the first form.
Use EXPLAIN:
http://www.postgresql.org/docs/7.4/static/sql-explain.html
--
(Posted from an account used as a SPAM dump. If you really want to get
in touch with me, dump the 'jboes' and substitute 'mur'.)
________
Jeffery Boes <>< jboes(at)qtm(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-09-02 14:26:42 | Re: C Function causes backend to die in 7.4.3 |
| Previous Message | Leonardo Francalanci | 2004-09-02 14:16:54 | R: "\d tablename" to get column name, and column type by using JDBC |