Key Columns: char vs. number

From: Jens Mayer <jmayer_at_ratundtat.com>
Date: Thu, 24 Jun 1999 07:39:32 GMT
Message-ID: <3771df06.6172285@news.space.net>

Hi folks,

yesterday I had a discussion with an Oracle-experienced friend about the question: is ist better to use CHAR or NUMBER datatypes in Key Columns, eg. in a Primary Key ?

Until now I thought that it's better to use CHAR, because NUMBER takes 22 Bytes of Space in each case. My friend mentioned, that using NUMBER in Key Columns makes better performance.

Who is right ?

Jens

Jens Mayer
Rat & Tat Beratungsgesllschaft mbH
Muehlenkamp 6c
22303 Hamburg Received on Thu Jun 24 1999 - 02:39:32 CDT