Database Administration & Monitoring
SQL Server: Heap page deallocation and IndexOptimize
23.01.2023 by Steven Naudet
Introduction HEAP tables are a type of data structure that, unlike a clustered index table, does not have a specific ordering of its rows, making them faster to insert and delete data. They are often used for temporary “staging” tables.