Which Gives Better Performance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Which Gives Better Performance

  1. #1
    Join Date
    Dec 2003
    Location
    Mehamadabad
    Posts
    14

    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

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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
  •  


Click Here to Expand Forum to Full Width