November 16, 2010 at 3:29 am
Hi All!!
Difference between the char and varchar data type in performance point of view?
What will the impact on performance (memory or I/O) if I convert char type of column to varchar?
November 16, 2010 at 12:11 pm
I would expect the change in performance to be very little.
But you may recover more disk space by changing to variable character columns. i.e. the database may have more space availbale to grow after you make the data type change.
Personally, i do not use char very often, unless the column needs to be only 1 or 2 in lenght. I have even seen columns defined as varchar (1), and that makes no sense at all.
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply