Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vinoth
Adding to the above points,
Rows will be distributed evenly among the AMP's if you specify the Primary Index for a table.
If you able to use the One AMP operation then you will be able to retrieve faster results. If you use all the AMP then it's called as Full table scan and the query results are very slow here.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the teradata primary index mechanics in detail with a diagram.
What is meant by a node?
List out some of the primary characteristics of teradata.
Explain the term 'row' related to relational database management system?
What tools would you use for that?
What is the difference between fastload and multiload?
Which is more efficient group by or distinct to find duplicates?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Explain the meaning of Amp?
What is the maximum number of dml can be coded in a multiload script?
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?
Why do you get spool space errors? How do trouble-shoot them?
Can we collect statistics on multiple columns?
What is called partitioned primary index (ppi)?
What are the enhanced features in teradata v2r5 and v2r6?
