Re: innodb not using correct index

2002-10-15 Thread walt
On Tuesday 15 October 2002 10:59 am, Heikki Tuuri wrote: > Walt, > > - Original Message - > From: "walt" <[EMAIL PROTECTED]> > To: "Heikki Tuuri" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, October 15,

Re: innodb not using correct index

2002-10-15 Thread Heikki Tuuri
Walt, - Original Message - From: "walt" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 5:56 PM Subject: Re: innodb not using correct index > Heikki Tuuri wrote: &

Re: innodb not using correct index

2002-10-15 Thread walt
Heikki Tuuri wrote: > Walt, > > - Original Message - > From: "walt" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Saturday, October 12, 2002 11:20 AM > Subject: innodb not using correct index > > > Is there a way to find out what index an sql query is using? I know you

Re: innodb not using correct index

2002-10-13 Thread Heikki Tuuri
Walt, - Original Message - From: "walt" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, October 12, 2002 11:20 AM Subject: innodb not using correct index > Is there a way to find out what index an sql query is using? I know you can > use explain, but those are jus