Hi,
I'm making a billing software. I'm using oracle as a database.
In my database design I'm planning to place all the billing information in one single table.
And inside that billing table I will put the other information like (meter reading information) in a nested table. There may be 5-6 nested table data type in this billing table.
I have chosen this concept to make the billing process faster(During accessing the billing information). I know I can achieve that by joining tables.
Now my question is - is it a good decision to go with the nested table concept ?
Will the performance be good when there will be 5-10 thousand rows for each month billing ?