<div>
surely it will. use Explain &lt;QUERY&gt; to find out index hints. <br />
If you can post your queries and table definition it'd be clear picture.
</div>


surely it will. use Explain <QUERY> to find out index hints.
If you can post your queries and table definition it'd be clear picture.

<div>
Ltorres, &nbsp;will delete also be increased in addition to insert times when there is an index? &nbsp;I am actually comparing the tables and removing records.
</div>


Ltorres,  will delete also be increased in addition to insert times when there is an index?  I am actually comparing the tables and removing records.

<div>
Yes corect deletes as well<br />
<br />
Here is a good resource<br />
<a href="http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/data_acc.htm" rel="ugc">http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/data_acc.htm</a><br />
<br />

</div>


Yes corect deletes as well

Here is a good resource
http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/data_acc.htm [http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/data_acc.htm]



<div>
<div class="content wysiwyg-content">
I am comparing 2 tables each with common field called mniNum and removing duplicate records from the one table by comparing records in each table. &nbsp; If I create an index in each table using the common field will that help speed up the process?<br />
<br />
What else can I do to speed up a query that must compare each record between two tables?
</div>
</div>


I am comparing 2 tables each with common field called mniNum and removing duplicate records from the one table by comparing records in each table.   If I create an index in each table using the common field will that help speed up the process?

What else can I do to speed up a query that must compare each record between two tables?

MySQL speed up query with index?

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.