Translations:Developers/Optimize performance/10/en

The MySQL optimizer always tries to find the best index for the given query but sometimes it's choice is totally wrong (see also). There are also cases where the correct index is chosen but only a part of the index is used even if much more matching key parts are available. Such a problem can occur when searching for items associated to products.