Table Size = Sum of Column Lengths Index = Column Length of Primary & Foreign Keys Secondary
Fantastic news! We've Found the answer you've been seeking!
Question:
- Table Size = Sum of Column Lengths
- Index = Column Length of Primary & Foreign Keys
- Secondary Index = Customer Name (assume 25 bytes)
- Blocking Factor of 90%
- 40% Overhead (logging etc.)
- Then:
- N*(Table size + Index Size) * 1.1 Blocking * 1.4 Overhead
- Assume: 10,000 Customers, 10 order per customers/mo, 3 lines per order, 20,000 Product SKU's
- Calc Storage for 12 months activity
- Calc Next Year # Customers Grow 20% (frequency or orders & lines the same)
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date: