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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

626


Difference between stored procedure and macro?

673


What is node? How many nodes and amps used in your previous project?

663


Discuss the advantages of using partitioned primary index in a query?

524


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

589






What interface is used to connect to windows based applications?

577


What do you mean by tpt in teradata?

579


What are the 5 phases in a multiload utility?

600


What is the difference between global temporary tables and volatile temporary tables?

628


How many sessions of MAX is PE capable of handling at a particular time?

586


What happens in a conflict? How do you handle that?

612


What is the use of having index on table?

574


What are the frequently used data types in teradata?

587


What is partitioned primary index (ppi)?

552


What is spool space?

593