Archives of the TeradataForum

Message Posted: Mon, 02 Nov 2015 @ 20:13:56 GMT

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

When the optimizer knows only some of the USI columns, then it must perform an *All AMP*, full scan of the secondary index, which in many cases is better than scanning the entire base table.

Jim

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