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 ou

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

innodb not using correct index

2002-10-12 Thread walt
Is there a way to find out what index an sql query is using? I know you can use explain, but those are just "possible" indexes that the query might use. I'm trying to find out exacly what execution path it is taking. Something similar to Oracle's "set autotrace on;" MySql version - MySQL-Max-3