Re: Ref. table performance in Oracle

From: Joel Garry <joelga_at_rossinc.com>
Date: 1997/02/21
Message-ID: <1997Feb21.172544.25385@rossinc.com>#1/1

In article <5ei17p$1q2$1_at_kronos.crosslink.net> zubaly_at_z-ware.com (Philip Zubaly) writes:
>Hello --
>
>I have some general questions on schema design for performance in Oracle.
>Specifically, I'm looking for some guidelines on when to use reference tables
>with integer PK's (sequence-generated) with RI to child tables vs. storing the
>actual character values in the child tables.

I would suggest reviewing Oracle datatypes. The "integer" will have to be translated, slowing performance significantly.

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O

Received on Fri Feb 21 1997 - 00:00:00 CST