Hi!
On Aug 10, Bernhard Doebler wrote:
> Hi,
>
> I try to optimize my tables. To see possible "errors" I use SELECT
> statements with PROCEDURE ANALYSE. I have a table that holds unique
> strings and an index by whitch it's referenced to another table.
> PROCEDURE ANALYSE advises as datatype for the strings to take an enum of
> (String1,String2,String3,String4,String5,String6,... to 191) Why doesnt
> it simply (intelligently in that case) advise to take varchar(50)???
>
> Best regards
> Bernhard
Because ENUM takes less space and is faster.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php