On Mon, Oct 11, 2010 at 12:38 AM, AI Rumman <rummandba@xxxxxxxxx> wrote: > 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? If it's a regular old inner join it doesn't matter, the query planner will figure it out. If it's a left or right join then you (hopefullly) already know the order you need to use. If it's a full outer join again it doesn't matter, the query planner will figure it out. -- To understand recursion, one must first understand recursion. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
