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.