>MySQL version 3.23.43 for SCO 5.06 binary INTEL. >The point is that it doesn't make the rigth selection of the index >When it performs >explain select nfactura, nauclfe from auxiliar where nfactura like '30%' >order by nfactura; >The result we have is: >table type possible_keys key key_len ref rows Extra >auxiliar ALL nfactura_idx NULL NULL NULL 1028572 where used; Using filesort >The name of the table is "auxiliar" and the field "nfactura" is "unique >key" not null. >The rigth answer should be "key nfactura" but it isn't as you can see. >The same query works ok with other versions of MySQL 3.23.45 for FreeBsd
--------------------------------------------------------------------- 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
