Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ref. table performance in Oracle
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... OReceived on Fri Feb 21 1997 - 00:00:00 CST