Archives of the TeradataForum

Message Posted: Wed, 14 Apr 2004 @ 23:18:06 GMT

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

Hi All,

We have recently broken one of large tables in Teradata into smaller tables on tha basis of year.

The problem we are facing is that now, in queries, when we need the complete data as a join of two tables using a union clause, we get a spool space error. This was not happening when we were just using that single table in the queries.

Why is this happening ?

Rgds,

Rohit

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