It's my understanding that MySQL will only use one index per table on a
given query. For example...
SELECT * FROM HUGE_TABLE
WHERE col1 = val1
AND col2 val2
AND col3 val3 ;
If col1, col2, and col3 are indexed the query can only use one index, right?
Single index access is a problem when you
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 HUGE_TABLE
O WHERE col1 = val1
O AND col2 val2
O AND col3 val3 ;
O If col1, col2, and col3 are indexed the query can