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 |
Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
write lock is compatiable with which type of lock?
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
What are the different functions performed in development phase?
How can you track login parameters of users in teradata?
How do you verify a complicated sql?
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
What is the difference between correlated sub queries and inner queries?
Explain the types of join supports by teradata?
What is the default join strategy in Teradata???
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
What is the opening step in basic teradata query script?