Slow NOT searches

[Ed Kleban]

Advantage of making a VarChar field nullable is that you would be able to
distinguish between when a field legitimately contains an empty string,
either by default or explicit assignment, and when it contains no string at
all because none has been supplied for it.  You could achieve the same
result by choosing some arbitrary string of your choice to signify "no
string supplied", such as "NULL" for example.

Disadvantages are more storage required for storing the per-record isNull
information, and slower execution because the nullable information needs to
be taken into consideration for many operations you may perform on the
field.

That make sense?

--Ed 


On 12/28/05 6:46 PM, "jda" <jda at his.com> wrote:

> Hi Ruslan,
> 
> Is there any advantage to making a VarChar field nullable? Any disadvantage?
> 
> Thanks,
> 
> Jon
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta