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 recreating the index to no avail, and have
dropped other indexes that I thought might possibly be confusing the
optimizer. No improvement.
Is there a way, through the Perl DBI interface, to determine whether
a given SELECT query is using indexes?
Thank you for any assistance offered.
David Keeney
----
David Keeney [EMAIL PROTECTED]
Travel By Road http://www.travelbyroad.net
---------------------------------------------------------------------
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