Re: About Null Values ...

In article <34da0b73.38650622@192.168.1.2>, Manel Falc' <manel@semic.es> writes >Hi all, >What is your strategy about null values ? >Do you have columns keys that may accept null values ?. If so, do you >save blanks ? Generally I try to avoid nulls and keep columns not null. >There is a big problem with null values in columns-keys: NEVER have NULL values in column keys. Make them all not null. >If you have to join them with another table, it doesn't go .. . >But sometimes is necessary null keys !!, especially in complexes >colunns keys ... Try to avoid column column keys, pull the key out into anotehr table with a serial on it. I think all join columns should be serial <-> integer. These columns are indexes and indexes on serial's and integer's are smaller than indexes on chars. Hence more rows/page and less disk i.o. > >What do you do ? > > >--- > > > > >Ciao, > > Manel > >----------------------------------------------------- >SEMIC, S.A. >Lleida (Catalunya) >Spain >----------------------------------------------------- >Informix version: Informix SE 5.07 / RDS 4.x >Operating system: Unix SCO V 5.04 > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care