-
Which Gives Better Performance
Hi All,
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.
Thanks,
Ramchandra Jetwani
Ramchandra Jetwani
-
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.
Tamil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|