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
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