Re: Optimizing column widths

2011-06-19 Thread Tim Johnson
* Dan Nelson [110618 16:33]: > In the last episode (Jun 18), Tim Johnson said: > > Is there an optimal 'alignment' for column widths for > > varchar types? > > > > I.E., divisible by 8 or 10 or by powers of 2? > > No. Varchar fields are stored using only as many bytes as are in that > particula

Re: Optimizing column widths

2011-06-18 Thread Dan Nelson
In the last episode (Jun 18), Tim Johnson said: > Is there an optimal 'alignment' for column widths for > varchar types? > > I.E., divisible by 8 or 10 or by powers of 2? No. Varchar fields are stored using only as many bytes as are in that particular entry. The size in the column definition is