Archives of the TeradataForum

Message Posted: Thu, 07 Jul 2011 @ 22:16:10 GMT

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

Additionally, if you have a large system and if you only have a table with 1 block per AMP, index will never be used. It's a single IO for table scan compared to 2 IOs using SI.

Satish Patel
Morgan Stanley | Enterprise Infrastructure

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