15.00 - Collecting Statistics on NUSIs Defined Using ALL and ORDER BY - 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 NUSIs Defined Using ALL and ORDER BY

When you use the ALL and ORDER BY keywords in a CREATE INDEX request, you should always collect statistics on the column on which the index is defined. This permits the Optimizer to more accurately compare the cost of using a NUSI-based access path with range or equality conditions on the sort key column.