INSERT COST

General
Enthusiast

INSERT COST

Hi,

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.

1 REPLY
Enthusiast

Re: INSERT COST

Can aybody pls suggest what are the things to consider to optimize merge into statement.

Thanks in Advance,

Harshita