Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> PK, FK, and datatypes
Does anyone have a compelling reason for using anything other than integers
or long integers for this? Most of the PK's are driven off of sequences
anyway. I got into a debate recently with another DBA that a varchar2(30)
would be an adequate PK. I suggested that the performance hit would be
significant during joins - let alone the datatype conversion from INT (or
NUMBER) to Varchar2. We never did settle the matter and I am pretty
curious. I am relatively new to Oracle, but have worked with other RDBMS's
and would never think of a non integer PK.
thanks! Received on Thu Sep 28 2000 - 11:12:15 CDT
![]() |
![]() |