15.00 - Mandatory Use of Join Indexes - Teradata Database

Teradata Database Design

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

Mandatory Use of Join Indexes

Join indexes are never required and are rarely recommended for tables that are accessed frequently by OLTP applications. They are highly recommended for decision support applications because they often provide superior performance to large table joins and aggregate computations. See Chapter 11: “Join and Hash Indexes,” for details.