how sub queries and joins differs funcationally

From: "shreedhar" <shreedhar(at)lucidindia(dot)net>
To: "Postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: how sub queries and joins differs funcationally
Date: 2003-01-27 06:59:34
Message-ID: 001601c2c5d1$a646cdd0$1201a8c0@a4005
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

Can any body tell that how sub queries and joins differs funcationally.
Because sub queries taking lot of time than joins.

Regards,
Sreedhar

"Faith, faith, faith in ourselves, faith, faith in God, this is the secret
of greatness.
If you have faith in all the three hundred and thirty millions of your
mythological gods,
and in all the gods which foreigners have now and again introduced into your
midst,
and still have no faith in yourselves, there is no salvation for you. "
(III. 190)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ludwig Lim 2003-01-27 07:36:17 Re: [ADMIN] how sub queries and joins differs funcationally
Previous Message Jerry Asher 2003-01-27 05:48:33 restricting identd to just the loopback adapter.

Browse pgsql-sql by date

  From Date Subject
Next Message Ludwig Lim 2003-01-27 07:36:17 Re: [ADMIN] how sub queries and joins differs funcationally
Previous Message Bruce Momjian 2003-01-26 23:15:33 Re: PostgreSQL + SSL