Archives of the TeradataForum

Message Posted: Fri, 21 Mar 2002 @ 22:39:45 GMT

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

I am in a similar boat to Geoff, I actually tried this a long long long time ago. I had a table with approx 10 Million rows on a 70 AMP DBC-1012 runing V1r5 i think (I said this was a long long long time ago).

The test was as follows: Run a complex join against this table joining to a number of smaller tables. Split the table into approximately 2 equal halves and run the same query against the two "half tables". I tried both parallel (i.e. two querymans running the same query at the same time) and sequentially The end result was that the two half tables took about 20-30% longer than the one large table.

Disclaimer, this was on a DBC-1012 - things have moved on a long way since then.

I would suggest that you just try it - just like I did.

Good Luck

glenn Mc

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