As Oracle uses an index to enforce a primary key constraint, the following
database limit as found in the "Oracle9i Database Reference" (Chapter 4
Database Limits) is relavent:
Item Type Limit
Indexes total size of indexed column 75% of the database block
size minus some overhead
--
Hope this helps!
oraclehelp_at_dbdomain.cc
The Database Domain (http://www.dbdomain.com)
Online and CD Training for Oracle DBAs
Oracle Certification Training (OCA and OCP)
"xtanto" <krislioe_at_gmail.com> wrote in message
news:e1c9bd55.0409300620.7a995bd2_at_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 - 15:27:56 CDT
