how to convert MYSQL ENUM (char type) into ENUM (int type)
Comment: How to find wrong indexing with glance view
August 23, 2008 By 27 Comments
… so it can be converted to IN instead of using BETWEEN [1]. As all boolean operators are ‘AND’, mysql can use either… smart enough and read mysql performance related articles then you’ll store all those fields as enums or tiny int with dictionary (in…/using-union-to-implement-loose-index-scan-to-mysql/#comment-1695 2. http://dev.mysql.com/doc/refman/5.1/en/index…
