in reply to OT: Indexes in MySQL
Essentially performance for the single combined index vs two separate indices (not sure why they are referred to as indexes) is the same when you query using the first key or both keys.
The combined index is only effective if you don't plan on attempting to query using only the second key. Order of keys is important in a combined index.
|
---|