Archives of the TeradataForum

Message Posted: Tue, 27 Nov 2012 @ 12:27:03 GMT

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

Hi Fina,

First query is going for UPI, may be because data present in table is unique (date).

Second query is going for full table scan as optimizer may think that its better to go for a FTS (table may be smaller) than going for other.

Thanks,

Sughesh I S.

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