MySQL Forums
Forum List  »  Performance

CHAR vs VARCHAR
Posted by: Weydson Lima
Date: October 12, 2010 10:08AM

I had two columns defined as VARCHAR(50). At that time, I ran the procedure analyze feature and suggested me that I changed them to CHAR(50). However, I created some indexes on these columns. When I reran the procedure analyze, it suggests that I go back with VARCHAR.

My thinking was that CHAR is better than VARCHAR because it's a fixed-size column. I am not worried about disk space - which VARCHAR would win in this case I believe. My only concern is about the performance.

Options: ReplyQuote


Subject
Views
Written By
Posted
CHAR vs VARCHAR
4563
October 12, 2010 10:08AM
1577
October 13, 2010 05:54PM
1176
November 02, 2010 01:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.