Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Doubts

Status
Not open for further replies.
ashark

ashark

Programmer
Nov 21, 2002
31
IN
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
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top