Increasing no of amps will increase performance. Is this
true?
Answers were Sorted based on User's Feedback
Answer / dinesh
hi,
yes ofcourse its increasing performance against when work
load increases, in teradata performance wil not affect
because the work load is evevnly distributed acorss all the
amps.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / yuvaevergreen
yes...
>>increase the no of amps with same no of users--performance
increases proportionately.
>>increase the no of PEs to increase the no of sessions.
>>increse the no of disks to increase the data storage.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / himanshu
Yes. But in that case no. of users should be the same. i.e.
suppose there are 5 users requesting 50 MB data, so the no.
of users should not increase. If suddenly 10 users start
demanding the same data, performance would not increase
even if the no. of amps are increased...!!
| Is This Answer Correct ? | 0 Yes | 3 No |
What is bteq script in teradata?
What is the use of having index's on table?
What is node? How many nodes and amps used in your previous project?
What is the use of stored procedures in teradata?
Can any one plz provide the teradata interview questions?
if collect stats but it show low confidence why?
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
How many macros we can create inside a macro
Explain teradata utilities?
What are the components used in smp and massively parallel processing (mpp) machines?
What are default access rights in teradata?
What is the purpose of indexes?