Received: from lin.local.lan ([216.221.221.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA9Fv2s56909 for ; Thu, 9 Nov 2000 10:57:02 -0500 (EST) (envelope-from najm@mondo-live.com) Received: from mondo-live.com (IDENT:najm@ll51.local2.lan [192.168.2.51]) by lin.local.lan (8.9.3/8.8.7) with ESMTP id NAA29716 for ; Thu, 9 Nov 2000 13:15:57 GMT Message-ID: <3A0C1B60.9B4A97E5@mondo-live.com> Date: Fri, 10 Nov 2000 10:59:28 -0500 From: Najm Hashmi X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0BOOT i686) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: [sql]Joins Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/74 X-Sequence-Number: 105 I am facing a dilemma at my work, I am using postgres first time. For some reason, my co-workers think that in Postgres joins i.e. simple joins of two or three tables are so bad that their cost is exponential. They believe that postgres simply takes Cartesian product of joining table in order to obtain desired tuples i.e. no optimization is done. I refused to believe so. I need your help to convince them that it is okay to join tables --two or three tables :)-- so we can eliminate redundancies from the database. I also want to know how postgres optimizes a join query. Thank you very much your help. Regards Najm