Hi, I am suffering with performance issue when using MERGE INTO command. The table have 8 columns, and types such int, string, float. The table count (*) = 1.2~ Trillion rows. The data Im trying to merge is 10-50 or 100 records tops in single batch. The table is partitioned by year_month field. The table uses 4 columns Z order optimization. The merge into using join keys that are Z-optimized. Anyone can help?

4 columns might be too much for the z-order, depending on the cardinality and relationship between the columns. Are you joining on all 4 columns?

@Dominique Brezinski how to see the merge metrics?