Update - lazy/Intellegent?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Update - lazy/Intellegent?

  1. #1
    Join Date
    Jan 2002
    Posts
    148
    what does update do for a row of c1,c2,c3 col undergoing c1 alone update.

    1) Does RX lock and updates only the c1 - or -
    2) Does RX and refreshes the whole row - or -
    3) Refreshes the whole Block?

    Thanx
    Jr


  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    it locks the entire row till the transaction is commited or rolled back

    cheese
    anandkl
    anandkl

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