> ----- Original Message ----- > From: "MySQL Newsgroup" <@[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, April 19, 2002 2:55 PM > Subject: Re: Select with Order By that don't use my INDEX :( > > > > Subject: Re: Select with Order By that don't use my INDEX :( > > From: Vic Cekvenich <[EMAIL PROTECTED]> > > === > > Better yet, remove the order by. > > Make it sort by the index, ie, create an index that matches your select. > > Vic > > > > Dr. Frank Ullrich wrote: > > Can someone tell me more about this index that matches select ? My query is always different : explain SELECT * FROM Forums WHERE Field2=5020 AND Field3=0 ORDER BY >>Field4 DESC LIMIT 0,20;
1<Field2<8000 like category number in fact ... Field4 is a datetime Thanks David --------------------------------------------------------------------- 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