Storage of long record

From: <PatrickJ_at_kneip.com>
Date: 24 Sep 2001 09:10:16 +0200
Message-ID: <3baedc58_1@news.vo.lu>

Hi,

I am working on Oracle 8.1.7, and I am looking for the best way to store records with a lot of fields. Knowing that half of the fields will be almost always present, and the other half will be present in only 10% of the records, what is the best choice:
- Create 2 tables, one containing the fields that are almost always
present, and the other containing the fields rarely present. By this way, I can spare the space of the rarely present fields in 90% of the cases, but programming is more complex.
- Create only 1 table with all the fields. In this case, does Oracle
optimise the storage, or does it reserve space even if the fields are Null?
- Other suggestion?

Thank you for your help.

Patrick J. Received on Mon Sep 24 2001 - 02:10:16 CDT