Archives of the TeradataForum

Message Posted: Mon, 30 Oct 2006 @ 17:51:47 GMT

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

Check for current statistics on all of the joining and filtering columns. Also look at the product join in step 10) substep 1). The row count may not be accurate causing this part to run longer.

Also look at performance monitor while the query is running to see which step it is spending it's time on.

Ed

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