Category: TD Basics

Teradata No Primary Index Tables

no primary index, NOPI, nopi in teradata, no primary index, teradata 14, pi in teradata, no primary index table in teradata, no primary index, no primary index table

Partition Primary Index – Advantage and Disadvantage

partition primary index, PPI in teradata, partition, SI and PPI, PPI, different index in teradata, Multilevel partition

Partition Primary Index – Basics

partition primary index, PPI in teradata, partition, SI and PPI, PPI, different index in teradata, Multilevel partition

Compression in Teradata

compression

compression in teradata, compression teradata, compression, reduce disk space. compress columns, compress syntax, compression on fixed

Secondary Index in Teradata

Secondary index in teradata, USI, NUSI, SI, unique secondary index, non unique secondary index, all amp operation, 2 amp operation, creation of secondary index

Collect Statistics in Teradata

collect stats, collect stats teradata, collect stats on table level, collect statistics in teradata, collect statistics, collect statistics on teradata

Join Indexes

join index in teradata, aggregate join index, join in teradata, joins in teradata, JOIN INDEX, joins