General information
Forum:
Microsoft SQL Server
>>Can anyone give me an idea of performance degradation with the use of a varchar column vs a char column? I know that space-wise, varchar is better if the sizes vary a lot. But, I don't know what kind of performance hit I'll get from a varchar.
>>
>
>Hi Bonnie,
>
>The one place where varchar data type can slow things down is UPDATE and only if new value causes row to be moved because there's not enough room on the page for in-place update. The queries would rather benefit from varchar data types because more rows could fit on one page so it'll require fewer physical reads which are more expensive that anything else.
Sergey;
Now that I fully understand! The other answer seemed to contradict itself and just added confusion to the issue. Besides, I have only had one cup of Green Tea this morning and I am not ready for deep thoughts! :)
Tom
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only