sql optimize Please help me. I can't understand why i've got this results.I have very simple table with name cz Field Type Null Key Default Extra Privileges tv int(11) MUL 0 select,insert,update,references rez_id int(11) 0 select,insert,update,references it filled with tv rez_id 2 0 2 0 2 0 2 0 2 0 2 0 1 0 1 0 when i do: desc select rez_id from cz.rez_inc where tv=1 i got: table type possible_keys key key_len ref rows Extra rez_inc ref tv tv 4 const 2 where used but,when i do: desc select rez_id from cz.rez_inc where tv=2 table type possible_keys key key_len ref rows Extra rez_inc ALL tv NULL NULL NULL 8 where used is it right? (i mean diffrent TYPE ,key ,ley_len) may be you can advise some articles about mysql optimisation? thanks. -- _______________________________________________ Talk More, Pay Less with Net2Phone Direct(R), up to 1500 minutes free! http://www.net2phone.com/cgi-bin/link.cgi?143 --------------------------------------------------------------------- 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