Archives of the TeradataForum

Message Posted: Mon, 26 Nov 2012 @ 14:44:10 GMT

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

Hi Fina,

2nd query is going for a full table scan (multi amp operation) unlike the first query. Please try to have the range partition on fec_inicio_vigencia date column and then try your 2nd query for better results.

Thanks,

Prasanna

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