Index Size & Overhead: B-tree Leaf Pages, Fill Factor & Indexes vs Table
This lesson is part of the course
In this lesson
You size the four B-tree indexes on the shipments table: entries per page with a 90 % fill factor, leaf pages, MiB per index and how big all indexes are compared with the table itself.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Row Size from Column Types & Table Size: Bytes per Row, Rows per Page, GiB Locked
- Index Size & Overhead: B-tree Leaf Pages, Fill Factor & Indexes vs Table Locked
- Database Storage Forecast: Compound Monthly Growth, Overhead & Months Until the Disk Alert (Chart) Locked
- IOPS & Throughput from the Query Mix: Reads, Amplified Writes & the Peak Locked
- Cache Hit Ratio & Buffer Pool Sizing: Working Set, Headroom & the RAM to Buy Locked
- Replicas, Backups & Retention: The Real Storage Footprint of One Database Locked
- Connection Pool Sizing with Little's Law: Busy Connections, Pool per Instance & Limits Locked
- Cost Comparison: Instance Sizes vs Serverless per Month (with a Chart) Locked