_____ and _____ are true about the Primary Index
-
Defined immediately after the table CREATE statement, used to find the Primary Key
-
Defined during the table CREATE statement, used to assign rows to an AMP
-
Defined immediately after the table CREATE statement, used to assign rows to an AMP
-
Defined during the table CREATE statement, used to find the Primary Key
The Primary Index is defined within the CREATE TABLE statement (not after). Its core purpose is to distribute rows to AMPs via the hashing algorithm. It is not used to find the Primary Key - PK is for uniqueness and relationships.
In Teradata, the Primary Index (PI) is defined as part of the CREATE TABLE statement (not afterward), and its main purpose is to determine data distribution — it is hashed to decide which AMP (Access Module Processor) will store each row. It is not primarily about enforcing or locating the Primary Key (that's a separate constraint, often unrelated to the PI). The other options incorrectly claim it's defined 'immediately after' the CREATE statement or tie its purpose to the Primary Key rather than row distribution.