<div>
Because only 1 index can be used at once.
</div>


Because only 1 index can be used at once.

<div>
<div class="content wysiwyg-content">
Mysql show unused indexes, also while i run a explain query on a select &lt;&gt;&nbsp;&lt;table&gt; having two indexes on the same column it shows both the indexes in possible keys but only one in used keys 
</div>
</div>


Mysql show unused indexes, also while i run a explain query on a select <> <table> having two indexes on the same column it shows both the indexes in possible keys but only one in used keys 

Mysql show unused indexes

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.