Heap tables (before SQL Server 2016)
GPTKB entity
Statements (19)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:database_table_type
|
| gptkbp:deletesAndUpdates |
can cause fragmentation
|
| gptkbp:featureChangeAfter |
improvements in SQL Server 2016
|
| gptkbp:hasClusteredIndex |
false
|
| gptkbp:nonClusteredIndex |
can be created
points to RID |
| gptkbp:notRecommendedFor |
frequent range queries
tables with frequent updates and deletes |
| gptkbp:performanceContext |
faster for small, staging, or temporary tables
slower for large tables without indexes |
| gptkbp:rowLocation |
row identifier (RID)
|
| gptkbp:storage |
unordered pages
|
| gptkbp:suitableFor |
ETL staging
temporary data |
| gptkbp:tableScan |
full scan required for data retrieval
|
| gptkbp:usedIn |
gptkb:Microsoft_SQL_Server
|
| gptkbp:bfsParent |
gptkb:Columnstore_Indexes
|
| gptkbp:bfsLayer |
8
|
| https://www.w3.org/2000/01/rdf-schema#label |
Heap tables (before SQL Server 2016)
|