plz explain parlla distribution and subtable concept in teradata
Answer Posted / yuvaevergreen
Parallel distribution: TD stores the data uniformly. Ideally, every amp should have equal no of rows from each table in vdisks.Based on the primary index, the distribution of data would be uniform on amps.
Sub table: It is used for secondary indexes and stored in amp(s).
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain the term 'primary key' related to relational database management system?
What is the purpose of using case expression in teradata?
Explain the term 'tables' related to relational database management system?
If a Node is busy what are the steps you can take to avoid ?
Steps to create a data model?
Explain PDE.
In BTEQ, how are the session-mode parameters being set?
What is collect statistics?
How do you set the session mode parameters in bteq?
List the logical and conditional operators that are used with teradata along with their meanings?
What are the available primary index types in teradata.
Can we collect statistics on table level?
What is teradata? What are some primary characteristics of teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?