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
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Comment whether bottleneck is an error or not.
What are the different table types that are supported by teradata?
Explain how spool space is used.
How you will check the version of teradata?
What is meant by a Highest Cost Plan?
Write a program to show the parser component used in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
Highlight the points of differences between the database and user in Teradata.
How to identify ppi columns?
What is teradata?
What is meant by a Channel Driver?
What is the opening step in basic teradata query script?
What is the meaning of Caching in Teradata?
What are the frequently used data types in teradata?
