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 being used: Execution is very slow.
The ouput of EXPLAIN only tells you which index(es) MySQL will
consider using. It does not tell you for sure that it will use them
all:
http://www.mysql.com/doc/E/X/EXPLAIN.html
Have you tried running an OPTIMIZE TABLE to see if that helps?
Of course, if you show us the table structure and the output of
EXPLAIN, we may be able to suggest something.
> Is there a way, through the Perl DBI interface, to determine whether
> a given SELECT query is using indexes?
Not that I know of, no.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 116 days, processed 717,559,724 queries (71/sec. avg)
---------------------------------------------------------------------
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
