+ Reply to Thread
Results 1 to 3 of 3
  1. 10-10-2001 08:25 PM #1
    Kumud
    Kumud is offline Member
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    Does the length of primary key matters ? what are the problems if we have primary key of so many characters.
    Reply With Quote Reply With Quote
  2. 10-10-2001 08:40 PM #2
    sonofsita
    sonofsita is offline Member
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    i do not see any problem as long as it is unique
    sonofsita
    http://www.ordba.net
    Reply With Quote Reply With Quote
  3. 10-10-2001 09:05 PM #3
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    No It doesn't mater.. but it can be a little impractical. But it does depend on your data. I had a primary key of Varchar2(40). Because the unique key was made up of a combination on unix parameters that were generated and that is what the users wanted to be able to search on.

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules

 Click Here to Expand Forum to Full Width