Re: MERGE statement with parallel DML enabled deadlocks itself
- From: Sayan Sergeevich Malakshinov <malakshinovss@xxxxxxxxx>
- To: thomas.kellerer@xxxxxxxxxx
- Date: Thu, 7 May 2015 10:39:24 +0300
What we _can_ do though, is to include the partition key in the
where clause (where part_key = 1).
Due to partition pruning this should have the same effect, shouldn't it?
Yes, of course.
Am I right that each partition was defined with only one partkey value in
list?
--
Best regards,
Sayan Malakshinov
Oracle ACE Associate, Oracle performance tuning expert
http://orasql.org
Other related posts: