Archives of the TeradataForum

Message Posted: Tue, 21 Feb 2006 @ 20:46:26 GMT

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

It will not use it.

If you only provide part of the primary index it will be forced to use a full table scan unless you have a secondary index defined for the part that you did specify.

Mike Dempsey
Teradata Client Tools

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