design quest.

From: ed zappulla <zappullae_at_rcn.com>
Date: Mon, 12 Jul 1999 11:24:49 -0400
Message-ID: <7md1c0$gi4$1@autumn.news.rcn.net>

Hi all, I'm looking for some advice. I'm using Oracle 8.0.5. What I'm interested in is the design of reference type tables. Like a vehicle type. My current standard is to make these tables like this:

create table vehicle_type
(

id integer not null, -- PK cd varchar2(6) not null, -- Unique; usually less than 4 chars also. descp varchar2(75) null
)

Then to reference them in other tables by Id.

I'm thinking that the id field is not needed and I can use the code field.

I'm concerned about performance.

Any ideas....Ed Received on Mon Jul 12 1999 - 10:24:49 CDT