Archives of the TeradataForum

Message Posted: Thu, 23 Mar 2006 @ 11:04:52 GMT

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

The PI is a hash index. It can locate a single value quickly but not a range of values. The optimizer is forced to a full table scan unless there is a value-ordered index.

Kenton Andersen

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