Get Live Help
A database object that provides fast access to data in the rows of a table, based on key values. Indexes provide quick access to data and can enforce uniqueness on the rows in a table.
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.
See Windows authentication mode .
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.
Intent locks serve the following purposes:
Intent locks include intent shared (IS), intent exclusive (IX), and shared with intent exclusive (SIX).