Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Maximum Allowed length of PK ?

Maximum Allowed length of PK ?

From: xtanto <krislioe_at_gmail.com>
Date: 30 Sep 2004 07:20:55 -0700
Message-ID: <e1c9bd55.0409300620.7a995bd2@posting.google.com>


Hi All,

We are designing on Oracle 9i database. Many tables have PK on one column of
30 Varchar2 length. Some even with 50 Varchar2 column as PK.

Will this cause performance problem ?
What is the maximum 'allowed' length of one column as PK / Index without causing performance degradation ?

Thank you,
xtanto Received on Thu Sep 30 2004 - 09:20:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US