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 DYNAMIC SQL in TD?
What are the different methods ot loading a dimension table? A fact table etc?
How many sessions of MAX is PE capable of handling at a particular time?
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
what is the difference between primary index and secondary index?.
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Explain the term 'row' related to relational database management system?
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
What is teradata?
What are the newly developed features of Teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
why should we go Teradata over Oracle,what is the main differences?