Re: Mysql bug, doesnt use INDEX for ORDER BY!!

2001-07-23 Thread Gunnar von Boehn
On Mon, 16 Jul 2001, Benjamin Pflugmann wrote: > >If I understand it correctly, this is a known and fixed bug: > >>From http://www.mysql.com/documentation/mysql/bychapter/manual_News.html: >-- >F.2.3 Changes in release 3.23.38 >

Re: Mysql bug, doesnt use INDEX for ORDER BY!!

2001-07-16 Thread Benjamin Pflugmann
Hi. On Fri, Jul 13, 2001 at 02:10:54PM +0200, [EMAIL PROTECTED] wrote: > On Don, 12 Jul 2001, Gerald Clark wrote: > > >It may be the DESC that prohibits the use of the index. > >Try an normal ascending order. > > Thanks for you idea, but DESC has no influence whether Mysql uses the INDEX or no

Re: Mysql bug, doesnt use INDEX for ORDER BY!!

2001-07-13 Thread Gunnar von Boehn
Hello, On Don, 12 Jul 2001, Gerald Clark wrote: >It may be the DESC that prohibits the use of the index. >Try an normal ascending order. Thanks for you idea, but DESC has no influence whether Mysql uses the INDEX or not. I think maybe that this is a real _bug_ in mysql. :-( Does somebody k