Thanks
Mr Baig, October 18, 2016 - 6:55 am UTC
Really appreciate your quick response. Hats off...
In our application there currently there is not parallel executions.
Do we need check some parameters to enable or it will work for all?
If we do direct update but the updated column is not an index column then indexes on the table would be updated?
Is the virtual col approach reliable to meet business?
Ghassan, October 18, 2016 - 11:04 am UTC
In addition to the answer above that is very good.
Conseder to add virtual column as the reverse say col2 of that say col1
You could also update select with nologging col1= col2 and drop the col2 after dml.
You could also export and import with remap
You could also merge using the rowid hint (with parallel nologging )
You could also use the dbms redefinition. ..
Lot of solutions for a simple task
October 18, 2016 - 1:35 pm UTC
A virtual column is an interesting idea. It could get tricky to maintain if they need to update the original column.
index
A reader, October 18, 2016 - 8:17 pm UTC
Any reason you can't index the unindexed column? Even temporarily?
October 19, 2016 - 12:54 am UTC
You could - but to build that index, means a scan of the whole table...and if you are doing that, you may as well do the work there and then