16.20 - merge join - Query Scheduler

Teradata Query Scheduler User Guide

prodname
Query Scheduler
vrm_release
16.10
16.20
created_date
May 2017
category
User Guide
featnum
B035-2512-086K

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.