Answer Posted / saidulu
In PI(Primary Index) also we have 2 types ie (unique
PI ,Non unique PI)
how can we say unique column as primarIndex.If it is
non unique PI means it allows duplicates.
Now i am comming to which column as Primary Index
1.Frequntly using column.
2.Not regularly changing column
(Not at all changing values /rarely)
3.By default it takes as first column as PI
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of upsert command?
What are some primary characteristics of teradata?
How can you track login parameters of users in teradata?
What is a node in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are the joins in teradata?
What do you mean by teradata sql assistant?
Highlight all the modes that are present under Confidence Level.
What are the uses of client software involved in teradata?
What are types of partition primary index (ppi) in teradata?
What is the meaning of Caching in Teradata?
Highlight the need for Performance Tuning.
When tpump is used instead of multiload?
What is the primary index in teradata?
Can you connect multiload from ab initio?