Tahnks
Sent from Yahoo Mail. Get the app
On Monday, July 25, 2016 11:48 PM, "Aldo Caruso [email protected]
[firebird-support]" <[email protected]> wrote:
My advice is to create that field in the invoices table.
You will always have this field at hand without resorting to an outer join
with another table that only has two fields ( the invoice ID and this field )
each time you need to inspect it.
Aldo
El 25/07/16 a las 18:51, [email protected] [firebird-support] escribió:
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
#yiv8088435033 #yiv8088435033 -- #yiv8088435033ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8088435033
#yiv8088435033ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8088435033
#yiv8088435033ygrp-mkp #yiv8088435033hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8088435033 #yiv8088435033ygrp-mkp #yiv8088435033ads
{margin-bottom:10px;}#yiv8088435033 #yiv8088435033ygrp-mkp .yiv8088435033ad
{padding:0 0;}#yiv8088435033 #yiv8088435033ygrp-mkp .yiv8088435033ad p
{margin:0;}#yiv8088435033 #yiv8088435033ygrp-mkp .yiv8088435033ad a
{color:#0000ff;text-decoration:none;}#yiv8088435033 #yiv8088435033ygrp-sponsor
#yiv8088435033ygrp-lc {font-family:Arial;}#yiv8088435033
#yiv8088435033ygrp-sponsor #yiv8088435033ygrp-lc #yiv8088435033hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8088435033
#yiv8088435033ygrp-sponsor #yiv8088435033ygrp-lc .yiv8088435033ad
{margin-bottom:10px;padding:0 0;}#yiv8088435033 #yiv8088435033actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8088435033
#yiv8088435033activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8088435033
#yiv8088435033activity span {font-weight:700;}#yiv8088435033
#yiv8088435033activity span:first-child
{text-transform:uppercase;}#yiv8088435033 #yiv8088435033activity span a
{color:#5085b6;text-decoration:none;}#yiv8088435033 #yiv8088435033activity span
span {color:#ff7900;}#yiv8088435033 #yiv8088435033activity span
.yiv8088435033underline {text-decoration:underline;}#yiv8088435033
.yiv8088435033attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8088435033 .yiv8088435033attach div a
{text-decoration:none;}#yiv8088435033 .yiv8088435033attach img
{border:none;padding-right:5px;}#yiv8088435033 .yiv8088435033attach label
{display:block;margin-bottom:5px;}#yiv8088435033 .yiv8088435033attach label a
{text-decoration:none;}#yiv8088435033 blockquote {margin:0 0 0
4px;}#yiv8088435033 .yiv8088435033bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8088435033
.yiv8088435033bold a {text-decoration:none;}#yiv8088435033 dd.yiv8088435033last
p a {font-family:Verdana;font-weight:700;}#yiv8088435033 dd.yiv8088435033last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8088435033
dd.yiv8088435033last p span.yiv8088435033yshortcuts
{margin-right:0;}#yiv8088435033 div.yiv8088435033attach-table div div a
{text-decoration:none;}#yiv8088435033 div.yiv8088435033attach-table
{width:400px;}#yiv8088435033 div.yiv8088435033file-title a, #yiv8088435033
div.yiv8088435033file-title a:active, #yiv8088435033
div.yiv8088435033file-title a:hover, #yiv8088435033 div.yiv8088435033file-title
a:visited {text-decoration:none;}#yiv8088435033 div.yiv8088435033photo-title a,
#yiv8088435033 div.yiv8088435033photo-title a:active, #yiv8088435033
div.yiv8088435033photo-title a:hover, #yiv8088435033
div.yiv8088435033photo-title a:visited {text-decoration:none;}#yiv8088435033
div#yiv8088435033ygrp-mlmsg #yiv8088435033ygrp-msg p a
span.yiv8088435033yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8088435033
.yiv8088435033green {color:#628c2a;}#yiv8088435033 .yiv8088435033MsoNormal
{margin:0 0 0 0;}#yiv8088435033 o {font-size:0;}#yiv8088435033
#yiv8088435033photos div {float:left;width:72px;}#yiv8088435033
#yiv8088435033photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv8088435033
#yiv8088435033photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8088435033
#yiv8088435033reco-category {font-size:77%;}#yiv8088435033
#yiv8088435033reco-desc {font-size:77%;}#yiv8088435033 .yiv8088435033replbq
{margin:4px;}#yiv8088435033 #yiv8088435033ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8088435033 #yiv8088435033ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8088435033
#yiv8088435033ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8088435033
#yiv8088435033ygrp-mlmsg select, #yiv8088435033 input, #yiv8088435033 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8088435033
#yiv8088435033ygrp-mlmsg pre, #yiv8088435033 code {font:115%
monospace;}#yiv8088435033 #yiv8088435033ygrp-mlmsg *
{line-height:1.22em;}#yiv8088435033 #yiv8088435033ygrp-mlmsg #yiv8088435033logo
{padding-bottom:10px;}#yiv8088435033 #yiv8088435033ygrp-msg p a
{font-family:Verdana;}#yiv8088435033 #yiv8088435033ygrp-msg
p#yiv8088435033attach-count span {color:#1E66AE;font-weight:700;}#yiv8088435033
#yiv8088435033ygrp-reco #yiv8088435033reco-head
{color:#ff7900;font-weight:700;}#yiv8088435033 #yiv8088435033ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8088435033 #yiv8088435033ygrp-sponsor
#yiv8088435033ov li a {font-size:130%;text-decoration:none;}#yiv8088435033
#yiv8088435033ygrp-sponsor #yiv8088435033ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8088435033
#yiv8088435033ygrp-sponsor #yiv8088435033ov ul {margin:0;padding:0 0 0
8px;}#yiv8088435033 #yiv8088435033ygrp-text
{font-family:Georgia;}#yiv8088435033 #yiv8088435033ygrp-text p {margin:0 0 1em
0;}#yiv8088435033 #yiv8088435033ygrp-text tt {font-size:120%;}#yiv8088435033
#yiv8088435033ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8088435033
