Archives of the TeradataForum

Message Posted: Sun, 03 Jul 2005 @ 19:42:47 GMT

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

Hi,

I think you cannot compare the performance of a "sel count(*)" with the "insert into select ". Especially if you have defined an index on the column Event_Value_Date. In this case the count(*) is only accessing the SI and not the physical table to count the number of records.

Greetings

Christian

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