a transaction that holds a lock on a clustered index record
also holds a lock on the secondary index record.