Archives of the TeradataForum

Message Posted: Mon, 23 Jul 2012 @ 23:20:22 GMT

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

What are you trying to achieve?

A non-equi join (b.Id <> c.Id) is usually useless, because it returns an answer set almost as large as an unconstraint cross join.

That's why your dba created a global filter to prevent such queries (before they run out of spool).

Dieter

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