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 bteq utility in teradata?
Explain PDE.
What is meant by a Highest Cost Plan?
Why are oltp database designs not generally a good idea for a data warehouse?
During the Display time, how is the sequence generated by Teradata?
When tpump is used instead of multiload?
What are types of partition primary index (ppi) in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
Explain teradata architecture?
Why teradata is used?
How to run a query in teradata?
Why is the case expression used in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
What are the functions performed by bynet?
Explain how spool space is used.