Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Maximum Allowed length of PK ?
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