Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CS Isolation level - Indexed Access

Status
Not open for further replies.

diggermf

Programmer
Jun 16, 2008
20
US
Hi All,

I was going thru a book where I was studying about the "Cursor stability" Isolation level, in which it is mentioned as bleow:

"When a transaction using the Cursor Stability isolation level retrieves a row from a table via a cursor, no other transaction is allowed to update or delete that row while the cursor is positioned on it. Other transactions, however, can add new rows to the table as well as perform update and/or delete operations on rows positioned
on either side of the locked row— provided the locked row itself wasn’t accessed using an index "

From the above statement, if the row is accessed using an INDEX, all the rows will be locked and will not be updated /deleted just like "Repeatable read" isolation level?

Please clarify
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top