When a record is deleted from a table, to improve concurrency SQL Server does not physically remove the row from index Leaf levels. Instead, the record is marked as deleted (ghosted). At a later point, a housekeeping process asynchronously removes the ghosted records from the Leaf level. Until the records are removed, SQL Server must skip the ghosted records during Leaf level scans.
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center