join stratergies

Database
Enthusiast

join stratergies

Hi all
Can any one let me know more details about joing stratergies,how differnt are they from joins in teradata.
thanks in anticipation
3 REPLIES
Enthusiast

Re: join stratergies

Hi Vinaymohan,

The Join strategies/plans are the different methods by which teradata actually performs the join operation.
The Optimizer will decide which Join plan should be used for a query.
Merge Join, Nested Join, and Product Join are few join strategies/plans
Merge Join is the most commonly used join strategies/plans.

For more information on each of these join strategies do refer Teradata PDFs.

Regards,
Balamurugan
Enthusiast

Re: join stratergies

Hi Balamurugan,

Can u suggest any ebooks for Join strategies/Plans

Thanx
Sanket
Enthusiast

Re: join stratergies

The Teradata Manuals provide pretty good documentation for the various join strategies. I'd start there.