Doubts

[ashark]

Hi Freinds,
Please can anyone help me with these:

Which is the best answer for the Q
1. In Teradata's parallel environment, response time is as fast as
-the fastest AMP invloved
-slowest AMP involved
-sum of all AMPs involved
- average performance of all AMPs

2. Does a full table scan require less space than a table requires?

Regards,
ashark

 

[teradev]

ashark
for question one the answer is the slowest amp involved. even if the other amp's send the response back to bynet, it still need to wait for the slowest amp to send the response before sending response back to PE.
so the response is as fast as the slowest amp involved.

question 2 is not clear. sorry