KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Possible Duplicate: is there an advantage to varchar(500) over varchar(8000)? I understand that a VARCHAR(200) column containing 10 characters takes same amount of space as a VARCHAR(20) column containing same data. I want to know if changing a dozen VARCHAR(200) columns of a specific table to VARCHAR(20) would make the queries run faster, especially when: These columns will never contain more than 20 characters These columns are often used in ORDER BY clause These columns are often used in WHERE clause Some of these columns are indexed so that they can be used in WHERE clause PS: I am using SQL Server 2000 but will upgrade to later versions of SQL anytime soon.
Tags (comma-separated)
Save Edits
Cancel