I have a really big table containing over 100kk rows and I would like to update about 3kk rows. Following count returns 3kk and takes about 300s to execute select count(*) from A where x=.. and y=.. But the update statement is much slower… update A set z = .. where x=.. and y=.. V$Read more