Question

Differentiate between Char and Varchar datatypes in MySql.

Answer 1

size" it means the rows of your table must contain all fixed size fields. You get no performance improvement if you use CHAR against VARCHAR in one field, but the table contains other fields that are VARCHAR. – Marco Demaio May 20 '10 at 11:55

2

no char datatype adds the performance... while execuing the query sql will generate a execution plan. Assume there are 2 columns charcol char(2000) and VarcharCol Varchar(2000).In execution plan,estimated row size for varchar type of columns might be under estimated. thus it leads the spill over to temp db. So using char is good for performance – vignesh Oct 9 '14 at 10:37

1

@Marco why do we lose performance benefit in that scenario? – The Red Pea Aug 4 '16 at 6:58

what is the meaning of the value in