Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-04 : 09:17:04
|
| Aniruth writes "What should be the maximum no of columns in primary key for efficient normalisation" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-12-04 : 09:54:27
|
| The number needed.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2001-12-04 : 10:09:02
|
quote:
The number needed.
How poignant  Here is one school of thought (and the long winded version of nr's response), normalize to the third normal form. For an OLTP system that is usually the point where any further normalization causes system degredation due to excessive joins. Once you get to the third form you should already see what columns are going to be used as your primary key. At that point you could tinker with the system and de-normalize to try and gain system performance increases, if you do denormalize you may eliminate some of the columns needed to make up your pk. There is no hard and fast number to adhere to, it will vary from DB to DB.m2c,Justin |
|
|
|
|
|
|
Primary key