Hi Friend,

I am having question about database design.
Here we wil have database size of 4 tb. This database
performs only inserts and select operation. No update is going to occur. I am plannig to desgin one huge table of 82 fields
and going to partition and index it on 16 different columns.
We r using oracle 8i (8.1.6) and Sun solaries 2.8 on sun E6500
machine.

But my colleagues suggest me to go for more than one table and use joins while query
instead of one huge table.While one huge table is possible.

So what will be the best database design to get optimal
select query performance.

Thanks
Jayesh