On Mon, Oct 11, 2010 at 12:38 AM, AI Rumman <rummandba@gmail.com> 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.