Primary key type selection

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Sun, 14 May 2000 13:37:15 -0400
Message-Id: <10497.105597@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_01BFBDCB.0B34DFA0
Content-Type: text/plain;

charset="iso-8859-1"

Is there any advantages and disadvantages (performance? , ...) between NUMBER and VARCHAR2 for primary key column?

Alex Hillman

------_=_NextPart_001_01BFBDCB.0B34DFA0
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>Primary key type selection</TITLE>
</HEAD>
<BODY>

Is there any advantages and =
disadvantages (performance? , ...) between NUMBER and VARCHAR2 for = primary key column?


Alex Hillman


</BODY>
</HTML>

------_=_NextPart_001_01BFBDCB.0B34DFA0-- Received on Sun May 14 2000 - 12:37:15 CDT