index clarification

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
If I have a table with two indexes: indexA table(A), and indexB
table(B), and I create indexAB table(A, B) it produces two indexes, A
and B. Can I drop the indexes created earlier on those individual
fields and have mysql use the two indexes created by the create indexAB



Re: index clarification wrote:
Quoted text here. Click to load it

Depends what type of sorting you're planning on doing.
For instance, a query with ORDER BY B cannot use the compound index over

Bill K.

Site Timeline