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
What is oltp?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Difference between stored procedure and macro?
Explain the term 'row' related to relational database management system?
What are the steps involved after the disk manager passes the request?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the frequently used data types in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is teradata? Also, list out some of the primary characteristics of teradata.
Can you connect multiload from ab initio?
Difference between multiload and tpump?
What are the functions involved in shared information architecture?
What is the difference between fastload and multiload?
What is a clique?
