Ghost index in SQLSERVER

Before reading this article, you can take a look at the ghost index in SQLSERVER to learn about the ghost history in SQLSERVER. About the ghost history. About the ghost history. 2. delete a record in the table. when, the corresponding records on the index page are not deleted immediately, but marked as shadows. They are deleted only when transactions are committed.

Before reading this article, you can take a look at the ghost index in SQLSERVER to learn about the ghost history in SQLSERVER. About the ghost history. About the ghost history. 2. delete a record in the table. when, the corresponding records on the index page are not deleted immediately, but marked as shadows. They are deleted only when transactions are committed.

Ghost index in SQLSERVER

Before reading this article, you can take a look at Ghost shadows

Learn more about ghost history in SQLSERVER
Translation of ghosting records 1
Translation of ghosting records 2

When you delete a record in a table, the corresponding record on the index page is not deleted immediately, but marked as a ghost image. The index record is deleted only when a transaction is committed,

Or roll back the transaction, the ghost image index record will be restored to a normal index record, the purpose of this is to improve the performance

The ghost index only appears on the non-clustered index page. The clustered index page does not contain the ghost index.

Establish Environment

Testghostindexnoncluster (id int identity (1, 1), name varchar (20) testghostindexnoncluster (name) IX_testghostindexnoncluster ).