Amazon Interview Question
How to optimize merge statement with millions of rows?
Interview Answer
Anonymous
Feb 13, 2022
May be you can use partitioning scheme where you can define distribution keys and sort keys on certain columns such that the query becomes faster.