I have a qry with merge statement.
MERGE INTO TABLE A
USING TABLE B
ON A. COL (PI) = B.COL (PI)
when matched then update set col..list
when not matched then insert values.
I think in this type of query we cant tune anything 'coz directly accesing the PI column.
Is there anything else can be done to tune this type of queries.
Can aybody pls suggest what are the things to consider to optimize merge into statement.
Thanks in Advance,