Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VarChar
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Miscellaneous
Thread ID:
01110397
Message ID:
01110778
Views:
21
The only real downside to varchar is if you initially store a value in a varchar column with say, 10 characters and later change this value to say, 20 characters, the value gets fragmented into two separate physical areas on disk. Furthermore, if you change this same value to 30 characters you now have three non-contiguous areas that contain the value for the column. The database needs to do more work to construct this value, thereby causing a performance hit.

So, with this said, if you know a column will rarely, if ever, change, then varchar is a good choice.

HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform