Hmm, doing some database indexing on one of my sites and I have a question:
If I have an index that uses let's say, field1,field2,field3 is there any benefit of having another index that uses just field1,field2?
Thanks!
Yes and no.
Yes because if you do a query on field1 and field2, the database should find that the second index fits the requirements better. And because the second index is smaller than the first it should be faster.
No because the first index already covers field1 and field2, and because adding another index means more work during inserts and updates.
