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

How to Extract data from multiple legacy systems?

576


Highlight the limitations of TPUMP Utility.

608


What are the different table types supported by teradata?

537


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

1624


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

564






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

656


if collect stats but it show low confidence why?

1194


Highlight the need for Performance Tuning.

595


Explain teradata utilities. What is multiload, fast load, tpump?

577


What are default access rights in teradata?

632


What are the various indexes in teradata? How to use them?

572


Why teradata is used?

581


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

3117


What are the newly developed features of Teradata?

573


If RDBMS is halted what will you do ?

1710