Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VarChar
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Divers
Thread ID:
01110397
Message ID:
01110778
Vues:
20
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform