Archives of the TeradataForum

Message Posted: Thu, 05 Aug 2004 @ 20:50:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Nazy,

Queries that contain all-AMP operation steps will usually demonstrate linear scalability on Teradata (response time increasing proportional to the volume of data being operated on). In looking at test results, however, it is often the case that some queries will look better than linear, others less than linear. That's because certain query characteristics can impact how well the query scales. Large sorts, for example, are often non-linear as they tend to do disproportionately more work with more data to sort. And there may be uneven patterns in the growth of the data that may lead to different query plans at higher volumes. If there are joins in the query, and the data become more skewed with growth, and the skew is on the join columns, this could result in non-linear results.

So the answer is yes in general, but you have to consider the underlying characteristics of both the data and the query.

Thanks, -Carrie

	<Prev	Next>		<<First	<Prev	Next>	Last>>