Update performance of OracleDataTable

[hansjoergp]

Hello,

I would like to use the OracleDataTable class to select some columns of a table and update them.
Now for the Update statements is used always as where every column of the select and not the primary key (this happens also for an "select * from table_name").
For this the Update is less performant as it could be

Therefore the "Update" command has a much worse performance than it could have.
How can you influence this behaviour?

[Shalex]

Try setting OracleDataTable.ConflictOption=ConflictOption.OverwriteChanges.

Refer to https://www.devart.com/dotconnect/oracl ... ption.html.