Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 3DA2FB5DBD1
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  2 Aug 2011 03:42:23 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 67652-01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  2 Aug 2011 06:42:13 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp120.dfw.emailsrvr.com (smtp120.dfw.emailsrvr.com
	[67.192.241.120])
	by mail.postgresql.org (Postfix) with ESMTP id E9BC3B5DBC8
	for <pgsql-performance@postgresql.org>;
	Tue,  2 Aug 2011 03:42:12 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp22.relay.dfw1a.emailsrvr.com (SMTP Server) with ESMTP id
	9F5D7170307; Tue,  2 Aug 2011 02:42:11 -0400 (EDT)
X-Virus-Scanned: OK
Received: by smtp22.relay.dfw1a.emailsrvr.com (Authenticated sender:
	adarsh.sharma-AT-orkash.com) with ESMTPSA id 0B23A1701A7
	for <pgsql-performance@postgresql.org>;
	Tue,  2 Aug 2011 02:42:10 -0400 (EDT)
Message-ID: <4E379C43.7020805@orkash.com>
Date: Tue, 02 Aug 2011 12:12:11 +0530
From: Adarsh Sharma <adarsh.sharma@orkash.com>
User-Agent: Thunderbird 2.0.0.22 (X11/20090625)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Which Join is better
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201108/15
X-Sequence-Number: 44462

Dear all,

Just want to know which join is better for querying data faster.

I have 2 tables A ( 70 GB ) & B ( 7 MB )

A has 10 columns & B has 3 columns.Indexes exist on both tables's ids.

select p.* from table A p, B q where p.id=q.id

or

select p.* from table B q , A p where q.id=p.id


Thanks