Archives of the TeradataForum
Message Posted: Tue, 27 Mar 2007 @ 11:31:20 GMT
> Select tableA.pkey, tableB.* from tableA, tableB;
A tricky query to use for that purpose! I don't know what you mean by a 2-way join but from here the join looks like a Cartesian (cross) join.
The number of rows returned is the product of the number of rows in tableA and tableB. If on a test system the tables contained 1,000 rows each then the query would return 1 million rows. If on the prod machine you increased the number of rows to 10,000 rows then the result set would already contain 100 million rows, quite a different figure altogether. The system might not be able to handle this internally.
Anyway, there was a similar thread recently:
No suggestions for SysMaxRow tuning. I doubt it is tunable without NCR interference. You might need to give them a call or find yourself a more predictable test query.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|