Which Gives Better Performance
I want to know that UPDATE with FORALL bulk bind gives better result or an UPDATE query with an Select Query as an inline view will give better performance.
The update is done on single field but for multiple records in the database. The data for updation is available in Collection arrays. The same can also be available through select query which can be placed inside an update statement. I am confused which will give better performance in terms of execution time, not in terms of cost.
If a job can be done in a single statement, then do it. This is faster than any other method.
If not, use PL/SQL.
Click Here to Expand Forum to Full Width