Increasing no of amps will increase performance. Is this
true?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Highlight the limitations of TPUMP Utility.

613


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

660


What is smp and mpp platforms?

534


How is the teradata different from oracle?

627


What are the steps to create a data model?

607






How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1291


Explain the term 'foreign key' related to relational database management system?

564


Highlight all the modes that are present under Confidence Level.

548


List the logical and conditional operators that are used with teradata along with their meanings?

559


What is a level of granularity of a fact table?

647


How to load specific no.of records using bteq, or fastload,or multiload

1325


What are the different design perspectives used in teradata?

557


What are the available join types in teradata?

605


How do you see a ddl for an existing table?

582


Explain fastload in teradata?

604