Archives of the TeradataForum

Message Posted: Tue, 14 Feb 2006 @ 14:49:56 GMT

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

You should check the spool usage Teradata seems to have some issues with large unions we have abandoned them in our data warehouse, if you build a temp table with the first statement, then insert/select the other two you may see a large increase in performance.

Eric Barner
Database Administrator
Planning Systems Incorporated

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