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 PDE.
What are the various indexes in teradata? How to use them? Why are they preferred?
Write a program to show the parser component used in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is logical data model?
What is the difference between union and union all in teradata?
What is meant by a dispatcher?
How does hashing happens in teradata?
What are the uses of bynets in multi-node systems?
Where is teradata rdbms used?
How to eliminate product joins in a teradata sql query?
Describe the between keyword in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
