hi

Just browsing for db2 performance , i came across some important point
CREATE TABLE options
Avoid using the VARCHAR data type for columns of 30 bytes or less as it
typically wastes space; instead use CHAR. Wasting space can even affect
query times if the volume is significant.

This is from IBM OFFICIAL WEBSITE tips for "BEST PRACTICES FOR DB2 V8.1"
EXCLUSIVELY FOR UNIX,WINDOWS & AIX.

is this true

Thanks
Thiru


DB2 & UDB email list listserv db2-l LazyDBA home page