How long can/should a primary key be?
From: <flemir_at_tdbank.ca>
Date: 17 Mar 1995 13:36:53 -0500
Message-ID: <3kcks5$q8h_at_inforamp.net>
Date: 17 Mar 1995 13:36:53 -0500
Message-ID: <3kcks5$q8h_at_inforamp.net>
Could anyone tell me about things I should consider when defining a long primary key. We have a location table which will be 32 characters in length. The key will consist of an account number, and several address elements (house number, zip code etc.) What is the maximum length in bytes that a primary key can be? One consideration I can see is that it will take longer to drop and recreate indexes; is there anything else I should consider. Also, are there pros or cons for having a VARCHAR field in a primary key?
-- Rosemary Fleming Database Administration Toronto Dominion Bank flemir_at_tdbank.caReceived on Fri Mar 17 1995 - 19:36:53 CET