3.4.8 Lock sequence based on SQL statement and index types
(1) Lock sequence of data manipulation SQL statements for index key values and data page rows
(a) INSERT statement
![[Figure]](figure/zu030408.gif)
(b) DELETE statement that does not use a cursor or UPDATE statement to search for data matching a condition
![[Figure]](figure/zu030409.gif)
(c) DELETE statement that uses a cursor
![[Figure]](figure/zu030410.gif)
(d) UPDATE statement that uses a cursor
![[Figure]](figure/zu030411.gif)
(e) SELECT or FETCH statement
![[Figure]](figure/zu030412.gif)
![[Figure]](figure/zu03041a.gif)
![[Figure]](figure/zu030413.gif)
(2) Lock sequence of data manipulation SQL statements when non-locking of index key values is used
(a) INSERT statement
![[Figure]](figure/zu030415.gif)
(b) DELETE statement that does not use a cursor or UPDATE statement to search for data matching a condition
![[Figure]](figure/zu030416.gif)
(c) DELETE statement that uses a cursor
![[Figure]](figure/zu030417.gif)
(d) UPDATE statement that uses a cursor
![[Figure]](figure/zu030418.gif)
(e) SELECT or FETCH statement
![[Figure]](figure/zu030419.gif)
![[Figure]](figure/zu030420.gif)