what is the difference between primary index and secondary index?.
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
Distribution of data in TD depends on primary index. SI is not involved in distribution of data. PI is mandatory whereas SI is optional. SI, if not chosen properly, is just an overhead.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / tdguy
PI plays a very important role in teradata. It is used in
data distribution. Very important for joins. SI provides
alternate path for data access.
| Is This Answer Correct ? | 3 Yes | 0 No |
What's the syntax of sub string?
List out teradata data types?
What is teradata? What are some primary characteristics of teradata?
what is referential constraints?how do you implement RI in teradata?
What is meant by a dispatcher?
What are different table types used in teradata?
On which column will you take primary index???
Describe primary index in teradata?
Explain amp in teradata?
Can any one plz provide the teradata interview questions?
What is a level of granularity of a fact table?
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me