Re: Minimize locking on UPDATE with multiple WHERE columns
Posted by:
Rick James
Date: April 05, 2013 07:05PM
> WHERE row2 <= xx AND row1 IS NULL
For that, this index would be best:
INDEX(row1, row2) -- in this order.
Are you saying that that WHERE matches 100 rows?
Subject
Views
Written By
Posted
1766
March 17, 2013 09:07AM
1061
March 21, 2013 09:28AM
989
March 21, 2013 02:34PM
921
March 23, 2013 12:23AM
943
March 25, 2013 08:13AM
973
March 28, 2013 12:04AM
1003
April 05, 2013 01:38PM
Re: Minimize locking on UPDATE with multiple WHERE columns
917
April 05, 2013 07:05PM
965
April 05, 2013 07:32PM
987
April 05, 2013 10:16PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.