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 use of fallback?
Where is teradata rdbms used?
What are the joins in teradata and how many types of joins are there in teradata?
Highlight the points of differences between the database and user in Teradata.
What is the difference between teradata and basic rdbms?
What are the various indexes in teradata? How to use them?
What is the purpose of joins in teradata?
What are the primary characteristics of the Teradata.
If RDBMS is halted what will you do ?
What are the different table types that are supported by teradata?
Explain the term 'tables' related to relational database management system?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Did you write stored procedures in teradata?
Explain the advantages of partitioned primary index in a query?
What is the difference between union and union all in teradata?