When a column which contains long text, eg remarks, notes, may have in most cases less than 50% of the maximum length.
1. Can lead to high space utilization if most of the values are close to MAXIMUM.
2. Positioning of VARCHAR column has to be done carefully as it has performance implications.
3. Relocation of rows to different pages can lead to more I/Os on retrieval.
Give the exact DDL
First CREATE MANAGER table with EMP# as the primary key Then ALTER it to define the foreign key.
Recording SQL statements that access a table Specified at table creation time or through alter.
A DB2 bind is a process that builds an access path to DB2 tables.