IFW_DUPLICATECHECK and pipeline performance
Does partitioning the IFW_DUPLICATECHECK table increases the performance of pipeline significantly?
Also, as the volume of data in the IFW_DUPLICATECHECK table increases, does it degrade the perfomance of the pipeline? Or no effect at all?
Thank you.
Rafie.