Question: Table Size = Sum of Column Lengths Index = Column Length of Primary & Foreign Keys Secondary Index = Customer Name (assume 25 bytes) Blocking

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!