Diff Between Primary Index And Primary Key

What is the main difference between Primary Index and Primary key in teradata? and can we have this two on same column?

Questions by maheshanna

Showing Answers 1 - 9 of 9 Answers

dinesh

  • Mar 21st, 2013
 

Primary Index
--Always Unique
--Does not allow NULL values
--Optional for a table
--Values can’t be updated
--Does not allow Duplicates
--Does not choose best access path
--Used In Joins

Primary Key
--Can be Unique or Non Unique
--Allow NULL Value
--Not Optional
--Values can be updated
--Allow duplicates in NUPI
--Chooses best access path to data
--Used In Joins

Agnes Melbin R

  • Apr 11th, 2013
 

If i am not wrong , both the titles should be swapped from the above answer as follows ,

Primary Key
--Always Unique
--Does not allow NULL values
--Optional for a table
--Values cant be updated
--Does not allow Duplicates
--Does not choose best access path
--Used In Joins

Primary index
--Can be Unique or Non Unique
--Allow NULL Value
--Not Optional
--Values can be updated
--Allow duplicates in NUPI
--Chooses best access path to data
--Used In Joins

More over the main difference between PK and PI is that ,

PK is a logical data model term to uniquely identify a row .
PI is a physical database design term and it is used by amp to access/distribute rows to teradata DB

  Was this answer useful?  Yes

uday

  • Oct 13th, 2014
 

Primary Index in Teradata is used for loading and extracting the data from Database. (TD will load data Through PI
) and other hand PK is cluster index uniqe identifier. Pk will not allow Null and duplicates but for PI ok

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions