Archives of the TeradataForum

Message Posted: Tue, 27 Mar 2007 @ 11:31:20 GMT

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

          > 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:

www.teradataforum.com/teradata/20070215_000000.htm

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.

Regards,

Victor

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