Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need some statistics regarding the performance of Teradata, something like with a given hardware, given nodes and given AMPs - a table which has thousands of rows can be read in 't' secs. I need this information to analyze the feasibility of teradata.

share|improve this question

migrated from May 1 '13 at 17:37

This question came from our site for professional and enthusiast programmers.

You certainly meant at least hundreds millions of rows? What's the point if you're dealing with smallish data sets? – Nickolay May 1 '13 at 3:48

There are a multitude of factors that go into determining which Teradata platform and the configuration of the platform that will suite your needs. Teradata has spent untold amounts of money on intellectual property and decades of experience working with potential customers to help them properly size a configuration that not only meets the immediate needs of a customer but provides them capacity for which the environment can adequately grow and evolve.

I would strongly suggest you reach out to Teradata directly and engage them in a pre-sales capacity if your company is considering their technology to meet the needs of your data warehouse environment.

For a sandbox environment, you could may be able to get away with using the one terabyte version of Teradata Express on an adequately sized server or consider using Amazon EC2 to stand up a instance of Teradata to complete a proof of concept. It should be noted that either of these options should not be used to gauge the performance of a production environment for service level agreements but whether or not the technology will accomplish what you are trying to do.

share|improve this answer

yeah Rob!! you are right, there are number of factors that will determine the performance of any query. I have found one whitepaper on teradata that has 5 case studies where scalability is defined on different parameters.

This white paper has somehow answered most of my questions.

share|improve this answer
Great overview of Teradata. – RobPaller May 1 '13 at 14:25

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.