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
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Explain vproc in teradata?
Which is faster fastload or multiload?
What does Amp contain and what are all the operations that it performs?
Mention a few of the ETL tools that come under Teradata.
What are the various indexes in teradata?
List out all forms of LOCKS that are available in Teradata.
Give the sizes of SMALLINT, BYTEINT and INTEGER.
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
When tpump is used instead of multiload?
What is the purpose of upsert command?
Different phases of multiload?
Highlight the limitations of TPUMP Utility.
how do you manage the production space. what are the proactive methods you can take ?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
