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 |
How can you track login parameters of users in teradata?
Highlight the advantages of PPI(Partition Primary Index).
Can you fastexport a field, which is primary key by putting equality on that key?
How do you Generate sequence at the time of Display?
Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq
What are the uses of client software involved in teradata?
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
Can you connect multiload from ab initio?
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
What is Difference b/w PI & PPI?how to implement PPI?
Why MLOAD needs Work Tables?
how can we analyze the locks ?