It's my understanding that MySQL will only use one index per table on a
given query. For example...
SELECT * FROM
WHERE =
AND <
AND > ;
If col1, col2, and col3 are indexed the query can only use one index, right?
Single index access is a problem when you very large tables. What if you
h
Orr,
Friday, July 26, 2002, 12:13:17 AM, you wrote:
O> It's my understanding that MySQL will only use one index per table on a
O> given query. For example...
O> SELECT * FROM
O> WHERE =
O> AND <
O> AND > ;
O> If col1, col2, and col3 are indexed the query can only use one index, right?
