4 ms·
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 recomm
by bobbydreamer 7y 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.