Archives of the TeradataForum
Message Posted: Fri, 21 Mar 2002 @ 22:39:45 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|