Re: Opinion on table structure and accessibility

gl wrote:
> 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?
>
> 1) Create a table with data structure as
> loan_no, month_no, prin_os, int_os
>
> 2) 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.

Has anyone yet told you that option 2 is an abomination?

If this is something other than a classroom exercise definitely consider partitioning.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org