query plan and parenthesis

From: Jan Poslusny <pajout(at)gingerall(dot)cz>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: query plan and parenthesis
Date: 2003-06-13 09:41:29
Message-ID: 3EE99C49.8030001@gingerall.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have following view definition given by '\d' command: SELECT t1.col1
FROM ((table1 t1 JOIN table2 t2 ON ((t1.id = t2.id))) JOIN table3 t3 ON
((t2.some = t3.some)));
Is query planner able to optimize order of joining (t1, t2), t3 or must
join with order described by parenthesis ? This is very important for
joining small (50 rows) and huge (5M rows) tables.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2003-06-13 09:48:29 Re: [pgsql-www] [Fwd: Advertising not appearing on PostgreSQL.org]
Previous Message Justin Clift 2003-06-13 09:38:55 Re: [GENERAL] [HACKERS] SAP and MySQL ... [and Benchmark]