what is the difference between primary index and secondary index?.
Answer Posted / 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 |
Post New Answer View All Answers
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What do you mean by teradata intelliflex?
Which is more efficient group by or distinct to find duplicates?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
In BTEQ, how are the session-mode parameters being set?
How to select first n records in teradata?
What are the functions involved in shared information architecture?
What do you mean by teradata sql assistant?
what is object level locking ? where do appear this type of locking ?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Can you connect multiload from ab initio?
Difference between stored procedure and macro?
What is oltp?
What is partitioned primary index (ppi)?