Hey guys, need expect opinion on table design and access. For a loan
record which going to store 300 months of principal outstanding and
interest outstanding. Which is a better choice?
- Create a table with data structure as
loan_no, month_no, prin_os, int_os
- create a table with
loan_no, p_mth1, p_mth2, p_mth3 ... p_mth300.
The first method will have million of records which cause I/O
contention, the second method will have issue on selecting data
randomly. Is there any other way for this design? Thank you.
Received on Fri Mar 16 2007 - 09:45:34 CDT
