意向锁 meaning in English
intent lock
Examples
- Intent locks serve two purposes
意向锁有两种用途： - When locking pages , the database engine places an intent lock on the higher level objects containing the pages
当锁定页时，数据库引擎将在包含页的更高级别的对象上放置意向锁。 - Intent locks , row locks , and page locks all count toward the escalation count , unless they are temporary table locks
除非属于临时表锁，否则意向锁、行锁和页锁都将计入升级统计中。 - When locking rows or index key ranges , the database engine places an intent lock on the pages containing the rows or keys
当锁定行或索引键范围时，数据库引擎将在包含行或键的页上放置意向锁。 - Sometimes , the term update refers to any data modification , including insert , update , and delete operations . update lock
第二个任务在锁定该表之前不必检查各个页锁或行锁，而只需检查该表的意向锁。