Archives of the TeradataForum
Message Posted: Thu, 03 Jan 2013 @ 14:20:14 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|