15.00 - Collecting Statistics on Unique Join Indexes - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.