|
|
|
|
|
|
by bobbydreamer
2589 days ago
|
|
|
It mostly depends on what type of table it is, I am a Db2 DBA z/OS. From experience, PK is must for every table either composite or single column. FK not recommended for 24/7 high volume or transaction table, recommended to handle it via code for ease of maintenance. Column should be NOT NULL WITH DEFAULT, nulls introduces unnecessary additional where clause checks. |
|
|