(Using mysql 3.23.38 - commercial version)
I have a table that has two indexes: one on just creationTime
(iv_alert_creation_ix), and one on (state, creationTime) (iv_alert_state_ix).
When I issue this query:
explain select uuid from iv_alert
where state = 1
and creationTime =
Hi,
On Wed, 2002-03-06 at 11:12, Shankar Unni wrote:
(Using mysql 3.23.38 - commercial version)
I have a table that has two indexes: one on just creationTime
(iv_alert_creation_ix), and one on (state, creationTime) (iv_alert_state_ix).
When I issue this query:
explain select uuid
Steven Roussey wrote:
Any way to hint a particular index for a query?
From the manual (http://www.mysql.com/doc/J/O/JOIN.html)
Thanks. I missed that. Unfortunately, as I was afraid, this is a very
MySQL-specific way of doing it. But then, hints always are DB-specific, so
that's not too
Any way to hint a particular index for a query?
From the manual (http://www.mysql.com/doc/J/O/JOIN.html)
As of MySQL Version 3.23.12, you can give hints about which index MySQL
should use when retrieving information from a table. This is useful if
EXPLAIN shows that MySQL is using the wrong