Archives of the TeradataForum

Message Posted: Tue, 21 Feb 2006 @ 20:43:36 GMT

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

If PI is on 2 columns and your SQL is on 1 column then teradata will not use the PI. It will do a full table scan.

Check the Explain plan for details.

Thanks

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