merge join - Query Scheduler

Teradata Query Scheduler User Guide

Product
Query Scheduler
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
the1488824663377.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2512
Product Category
Teradata Tools and Utilities

In Teradata SQL, the type of join that occurs when the WHERE conditional of a SELECT statement causes the system first to sort the rows of two tables based on a join field (specified in the statement), then traverse the result while performing a merge/match process.