FK consideration

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Fri, 26 May 2000 13:37:43 -0400
Message-Id: <10509.106901@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFC739.1932D0F0
Content-Type: text/plain;

charset="iso-8859-1"

Let say I have a column ca in a child table which is FK for the parent table. What are pro and con if the value of this column will be NULL for records which does not have parents versus some default value. I understand that if I have an index on this column ROWIDs of these records will not be in index.

Alex Hillman

------_=_NextPart_001_01BFC739.1932D0F0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>FK consideration</TITLE>
</HEAD>
<BODY>

Let say  I have a column ca in a =
child table which is FK for the parent table. What are pro and con if = the value of this column will be NULL for records which does not have = parents versus some default value. I understand that if I have an index = on this column ROWIDs of these records will not be in index.  =


Alex Hillman


</BODY>
</HTML>

------_=_NextPart_001_01BFC739.1932D0F0-- Received on Fri May 26 2000 - 12:37:43 CDT