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 is the teradata different from oracle?
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
How do you create tables? Exact syntax, and create profiles, users in teradata?
plz explain parlla distribution and subtable concept in teradata
what is identity column in TD?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What type of indexing mechanism do we need to use for a typical data warehouse?
Highlight the differences between Primary Key and Primary Index.
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
What are two examples of an OLTP environment?
What are the functions of a Parser?
What is the use of stored procedures in teradata?