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?
Update performance of OracleDataTable
Re: Update performance of OracleDataTable
Try setting OracleDataTable.ConflictOption=ConflictOption.OverwriteChanges.
Refer to https://www.devart.com/dotconnect/oracl ... ption.html.
Refer to https://www.devart.com/dotconnect/oracl ... ption.html.