16.20 - Related Topics - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
For more information about:
  • Using primary indexes to enhance the performance of your databases, see Teradata Vantage™ - Database Design, B035-1094.
  • Distribution and retrieval of the data controlled using the Teradata Database hashing algorithm, see Row Hash and RowID.
  • Partitioning considerations, including information on column partitioning, called Teradata Columnar, see Teradata Vantage™ - Database Design, B035-1094, Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144, and Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .
  • Details on all the restrictions that apply to primary indexes and partitioned primary indexes, see CREATE TABLE in Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.
  • Criteria for selecting a primary index, see Teradata Vantage™ - Database Design, B035-1094.