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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different methods ot loading a dimension table? A fact table etc?

574


Explain some differences between mpp and smp?

591


What are default access rights in teradata? What explicit right can be given to a user?

649


What is database exceptions in teradata?

549


What is dimensional modeling?

589






In the Primary Index, what is the score of AMPs that are actively involved?

575


Comment whether bottleneck is an error or not.

619


Difference between star and snowflake schemas?

602


Explain teradata architecture in detail with a diagram.

613


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

677


what is object level locking ? where do appear this type of locking ?

3113


What are the various indexes in teradata? Why are they preferred?

557


What is the difference between fastload and multiload?

793


How to view every column and the columns contained in indexes in teradata?

585


Explain the new features of teradata?

565