Archives of the TeradataForum

Message Posted: Mon, 01 Mar 2004 @ 17:47:59 GMT

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

You probably should get rid of the NUSI, with a table that size it's doubtful the nusi would ever be selective enough to be used by the optimizer. When we dropped 2 of the 3 nusi's on a 2 billion row table our load rate went up by a factor of 3 (using multiload).

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