15.00 - Query Plan: No Join Index Defined - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Query Plan: No Join Index Defined

Without a defined join index, the execution plan for this query would typically redistribute the orders table into a spool file, sort the spool on o_custkey, and then perform a merge join between the spool and the customer table.