I found it at:

http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0404mcarthu
r/index.html?ca=dnp-314




The information contained in this e-mail message and any attachments is confidential and intended only for the addressee(s). If you are not an addressee, you may not copy or disclose the information, or act upon it, and you should delete it entirely from your email system. Please also notify the sender that you received this e-mail in error.
-----Original Message-----
From: Chuck Hamilton
[mailto:db2udbdba-ezmlmshield-x38078356.[Email address protected]
Sent: Tuesday, August 24, 2004 8:23 AM
To: LazyDBA Discussion
Subject: Re: db2 Design for performance

What server did you find this on?

----- Original Message -----
From: "thirumaran "
<db2udbdba-ezmlmshield-x86768118.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, August 24, 2004 9:28 AM
Subject: db2 Design for performance


> 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
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

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