Which Join is better

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Which Join is better
Date: 2011-08-02 06:42:11
Message-ID: 4E379C43.7020805@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Maria Arias de Reyna 2011-08-02 06:47:02 Re: Which Join is better
Previous Message Jan Wielgus 2011-08-02 06:22:36 Tsearch2 - bad performance with concatenated ts-vectors