DSA Studio
Search
Home
Sign in
Page Layout Checkpoint
Slotted pages and fragmentation.
1. Slotted pages provide:
Stable record IDs even if records move
Fixed-length records only
No need for compaction
Guaranteed free space
2. Fragmentation is caused by:
Deletes that leave holes
Only inserts
WAL writes
Index scans
3. True/False: Compaction should update slot offsets without changing slot IDs.
Submit quiz
Auto-advance on pass