To have a separate table for a single column is a good idea if the column will be of type BLOB and will be used just sometimes.
Greetings. Walter. On Mon, Jul 25, 2016 at 5:51 PM, shg_siste...@yahoo.com.ar [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > Hello! I have a FB 2.5 database with a tabla "invoices". I need to add a > field in that table which will be null most of the times. Lefts say, that > 90% of the records will have this new field in null. > > > What is your advice? To create a new table with a FK to "invoices" and > save the needed field in a separate table (only when the value is not null > of course) of just create the new field in the main "invoices" table? > > > I think I read somewhere that null fields use very little space in the > database. Is that true? > > > Thanks for any input!!! > > > Sergio > > >
