The table is defined without a primary index or primary AMP index.
You cannot specify a column name list following a NO PRIMARY INDEX specification.
If the preceding item in the index list is a partitioning clause that is not part of an index clause, you must specify a COMMA character preceding NO PRIMARY INDEX. Otherwise, the comma is optional.
For the complete set of rules that control primary index defaults, see Teradata Vantage™ - Database Design, B035-1094.
- INDEX
- Optional keyword you can include for readability.