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 upsert statement in teradata?
what is object level locking ? where do appear this type of locking ?
What are teradata utilities?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How to identify ppi columns?
What is basic teradata query language?
What are the different table types supported by teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is meant by a Clique?
what are the roles and responsibilities of teradata DBA ?