Posted by D. on 05/28/07 13:29
>
> Because of some other considerations (the 'first' VARCHAR column will
> cost an additional 5 bytes per row), when in doubt, I would choose CHAR
> over VARCHAR. In your case, I would choose VARCHAR(10) if the average
> length is 6 or smaller. Otherwise I would choose CHAR(10).
>
Usually the key is fully filled, so I think I'll try to change varchar to
char.
Davide.
[Back to original message]
|