Update performance of OracleDataTable
Posted: Tue 17 Mar 2020 07:45
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?
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?