15.00 - Collecting Statistics on Unique Join Indexes - 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 on Unique Join Indexes

You should always collect statistics on the primary index of a unique join index, whether it is user‑defined or system‑defined, so the Optimizer can use those statistics to most accurately estimate the cost of using a particular unique join index.