join order

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: join order
Date: 2010-10-11 06:38:45
Message-ID: AANLkTikyuToMorOR_Ak17Yzt4s39TWvbDcA4kb_qakGR@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I need to join two tales say TAB_A and TAB_B, where TAB_A is greater than
TAB_B in size and records.
Which Table should I put first in join order?
Any idea please.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2010-10-11 06:46:50 Re: join order
Previous Message Neil Whelchel 2010-10-11 04:15:56 Re: Slow count(*) again...