Archives of the TeradataForum
Message Posted: Sun, 21 Mar 2004 @ 11:17:53 GMT
If you do not specify a Primary Index as part of your 'Create Table' DDL, then the machine will create an index by checking the following criteria.
If there is a Primary Key specified, then the table is created with a Unique Primary Index using the Primary Key.
If there is no Primary key, but a column with Unique constraints, then the table is created with a Unique Primary Index using the first column with a unique constraint. (all other columns with Unique constraints are created as Unique Secondary Index).
If neither of these consitions are satisfied, then the table is created with the first column assigned as a non-unique Primary Index.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|