Archives of the TeradataForum

Message Posted: Wed, 11 Apr 2007 @ 13:52:22 GMT

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

What do the explains say? What changed after the collect statistics?

Sometimes the optimizer (being cost based) will chose to use more space so it can run faster.

Can't tell without the explains.

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