Re: Index use, Perl DBI

2001-04-29 Thread Jeremy Zawodny
On Sat, Apr 28, 2001 at 08:47:11PM -0600, David Keeney wrote: > > I have a situation where a query should be using an index, running > the query from the mysql terminal using the explain ... command > indicates it will use the index, but the actual execution speed > tells me the index is not bein

Index use, Perl DBI

2001-04-28 Thread David Keeney
I have a situation where a query should be using an index, running the query from the mysql terminal using the explain ... command indicates it will use the index, but the actual execution speed tells me the index is not being used: Execution is very slow. I have tried dropping and recreatin