From: Najm Hashmi <najm@mondo-live.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: [sql]Joins
Date: Fri, 10 Nov 2000 10:59:28 -0500
Message-ID: <3A0C1B60.9B4A97E5@mondo-live.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: najm@mondo-live.com
Subject: Re: [sql]Joins
In-Reply-To: <3A0C1B60.9B4A97E5@mondo-live.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox