15.00 - Collecting Statistics for Star Joins - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Collecting Statistics for Star Joins

You should always collect statistics on the primary index of small tables that you plan to join regularly to large tables to ensure maximal star join optimization.