Merge Statement Performance Not Impressive, Need Alternative Approach
I need to load data in target table and before loading it will check availability of data and if data is already available in target table then it will update the data otherwise it will insert new data.
To implement this requirement i have wrote a merger statement and its performance is not impressive.
Is there any alternative approach to address this requirement?
Note - I can not create any database object, only I have to create anonymous block and this will call by Shell script.