After a DELETE statement is execute

After a DELETE statement is executed, the table can still contain empty pages. For example, empty pages in a heap cannot be deallocated without at least an exclusive (LCK_M_X) table lock. If the delete operation does not use a table lock, the table (heap) will contain many empty pages. For indexes, the delete operation can leave empty pages behind, although these pages will be deallocated quickly by a background cleanup process.

After a DELETE statement is executed, the table can still contain empty pages. For example, empty pages in a heap can not be deallocated without at least an exclusive (LCK_M_X) table lock. If the delete operation does not use a table lock, the table (heap) will contain many empty pages. For indexes, the delete operation can leave empty pages behind, although these pages will be deallocated quickly by a background cleanup process.

After a DELETE statement is executed the table, can still contain empty pages. For example empty pages, in a heap cannot. Be deallocated without at least an exclusive (LCK_M_X) table lock. If the delete operation does not use a, table lock the. Table (heap) will contain many empty pages. For indexes the delete, operation can leave empty, pages behindAlthough these pages will be deallocated quickly by a background cleanup process.
.