Archives of the TeradataForum

Message Posted: Tue, 21 Oct 2003 @ 18:39:27 GMT

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

Have you run explains on both the query using sel * and the one selecting only three columns? You should be able to get some good clues as to what's changed by comparing the explains. Without more details, best guess is a spool is being built on a single amp somewhere in the process.

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