advice on query joining 10 tables

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: advice on query joining 10 tables
Date: 2010-05-10 18:40:12
Message-ID: 4BE8530C.6030605@fmed.uba.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all. Im triyng to see if i can improve the performance of a query
(mainly a 10 table join)

1) Besides of triyng to use indexes, there is some rules of thumb to follow?

2) Should i try to join the bigger tables last in the query?

3) There is some place for understanding EXPLAIN better?

Thanks!
Gerardo

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2010-05-10 20:11:25 Re: advice on query joining 10 tables
Previous Message Gnanakumar 2010-05-10 14:19:04 Invalid message format Exception