On 2 August 2011 08:42, Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> wrote:
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
Hi,
it really doesn't matter. PostgreSQL can reorder the joins as it likes.
And you can always check, but I think the plans will be the same.
regards
Szymon
