Archives of the TeradataForum

Message Posted: Tue, 15 Jan 2002 @ 13:51:04 GMT

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

I have read two responses that I think are good clues.

1) The volitile tables are also using spool, so the final select may not even be reached.

2)With UPI's on all tables, and an inner join, why is the Distinct qualifier needed at all? Couldn't the Select Count(a.ban)? I find that users have a bad habit of using distinct to keep from anayzing their results for join problems.

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