5.19 Describe the intent exclusive (ix) lock mode type
NOTE: the shading on this picture may not be accurate. Please click on
the picture to obtain a larger image, which is accurate.
Key points
- An intent exclusive (IX) lock indicates an intention to write data
(that is, acquire an X lock) at a lower level of granularity.
- An IX lock on a PUBLICROW table together with an IX lock on a page indicates
an intention to write to one or more rows on that page.
- An IX lock on a PUBLIC table indicates an intention to write to one or more
pages.
- An IX lock on a table indicates that the transaction wants to write to
some of the rows in the table (an X lock on a table indicates that the
transaction wants to write to all of the rows).
- An IX lock is also called a subexclusive lock.
Page last updated on November 29, 1995
|
Printable version
