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 a node in teradata? Explain
What are the different functions included in the server software?
Can you connect multiload from ab initio?
Explain the most common data types used in teradata?
What are normalization, first normal form, second normal form and third normal form?
Which is more efficient group by or distinct to find duplicates?
What are the string manipulation operators and functions associated with teradata?
What is the syntax for case when statement?
How to view every column and the columns contained in indexes in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
What are different table types used in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Explain the meaning of Amp?
How to identify ppi columns?
why use references rather than pointers in the public api, particularly for arguments which are modified?