Collecting statistics provides the Optimizer with the data demographics it needs to generate query plans. The more accurate and up to date the statistics, the better the Optimizer can decide on plans and choose the fastest way to answer a query.
Statistics can be collected from Teradata Studio for Tables, Hash, or Join index objects at Column/Table/Hash/Join level.
Queries provided in the following sections must be executed using the SQL Editor view.