At 5:46 PM -0500 11/8/01, Tony wrote:
>On Thursday 08 November 2001 10:55 am, Paul DuBois wrote:
>> At 10:00 AM -0500 11/8/01, Tony wrote:
>> >Does anyone know if putting (or grouping) varchar columns at the end of a
>> >table provides any performance improvements? My indices are all integers,
>> >but not have varchar columns in between several integer columns.
>>
>> You'll get a speed improvement only if all your columns are fixed length.
>> Otherwise the table has variable length rows, no matter the placement
>> of the variable length coluumns.
>>
>
>So then is the real purpose of using varchars, to save disk space? ( I
>realize this is probably a general database question, just trying to learn).
Right.
