s>>>> 2011/05/27 12:26 -0700, Daevid Vincent >>>> [a] the EXTENDED keyword doesn't seem to do anything different? I get the same columns and results??! <<<<<<<< "show warnings"
>>>> 2011/05/27 12:26 -0700, Daevid Vincent >>>> In other words, am I wasting my time trying to tweak my query and indexes here with the idea there's some magic incantation that will get this "right" or do I just have to accept it is what it is and it's not going to do any better. <<<<<<<< Well, in general, of course there are problems for which no heuristic works--and indices _are_ heuristics. Houmuch real time does it take? I have two tables, one of addresses, another of the people living there s names, for the join wherof "explain extended" shows the same, and it does not bother me because it takes so little time. The output is only 1324 rows long. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
