A number that uniquely identifies an index on a table. All tables have at least an indid of 0 or 1. Indid 1 corresponds to a Clustered index, indid 0 corresponds to a Heap structure. Also called IndexID.
Intent locks are locks used by the database in order to protect a resource that is found lower in the lock hierarchy from a shared (S) lock or exclusive (X) lock. Because these locks are acquired before a lock at the lower level, they signal intent to place locks at a lower level.
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center