<div>
if this query is called so many times in an hour, then , creating the index is not a bad option. You should not that, indexes wont always improves performance, it can only improves the perfromance during the retrieval operation
</div>


if this query is called so many times in an hour, then , creating the index is not a bad option. You should not that, indexes wont always improves performance, it can only improves the perfromance during the retrieval operation

<div>
well, it will certainly help, otherwise the tree traversal (or the cost in short) for sorting will be much more.
</div>


well, it will certainly help, otherwise the tree traversal (or the cost in short) for sorting will be much more.

<div>
Should I create a composite index(intl, level, score) or two indexes: index(intl, level) and index(score)? &nbsp;Thanks!
</div>


Should I create a composite index(intl, level, score) or two indexes: index(intl, level) and index(score)?  Thanks!

<div>
I agree with Lowfatspread that the composite index will give the best performance
</div>


I agree with Lowfatspread that the composite index will give the best performance

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I know that you should create indexes on the &quot;where&quot; parameters, but I was wondering if you should create indexes on the &quot;order by&quot; paramters. &nbsp;For example, in the query below, should I create an index on the &quot;score&quot; field?<br />
<br />
select * from table where intl='us' and level='2' order by score;<br />
<br />
Thanks for your help!
</div>
</div>


Hi,

I know that you should create indexes on the "where" parameters, but I was wondering if you should create indexes on the "order by" paramters.  For example, in the query below, should I create an index on the "score" field?

select * from table where intl='us' and level='2' order by score;

Thanks for your help!

Create index on &quot;order by&quot; parameter?

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.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Create index on &quot;order by&quot; parameter?

Create index on "order by" parameter?