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
Syntax for case when statement?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What do you mean by tpt in teradata?
What are the frequently used data types in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is upsert statement in teradata?
What is teradata and why it is used?
What is the difference between fastload and multiload?
How to run a query in teradata?
What happens when a node suffers a downfall?
Explain vproc in teradata?
Highlight the need for Performance Tuning.
Comment whether bottleneck is an error or not.
What is the syntax for case when statement?
Explain the teradata primary index mechanics in detail with a diagram.