Indexes can facilitate access to data of interest in a database. Teradata Database offers several different types of indexes that can help to optimize the performance of your relational databases.
Every table is associated with a map that determines the AMPs to which the table rows are distributed.