Archives of the TeradataForum

Message Posted: Thu, 03 Jan 2013 @ 14:20:14 GMT

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

Hi Experts,

We have a huge table having more than 12 Billion rows and Multi level PPI on it.

Currently we are doing Delete + Insert as there is a huge volume of data need to get updated.

We are thinking of changing it into UPSERT or MERGE INTO.

Did anybody did any performance comparison on these?

We want to know which will perform better and which is better under which scenario.

Appreciate your time.

Thanks in advance,

Sughesh I S.

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