title: Trying to ForceIndex MYsql
body: <pre><code>mysql&gt; EXPLAIN SELECT fldjobitemid, fldstatus, tblbulkreportjobitems.fldparticipantid, CONCAT(fldFirstName, ' ', fldLastName) as full_name FROM tblbulkreportjobitems FORCE INDEX (fldparticipantid) JOIN tblparticipant ON tblparticipant.fldParticipantId = tblbulkreportjobitems.fldparticipantid WHERE fldjobid = 9 ORDER BY fldjobitemid
      -&gt; ;
  +----+-------------+-----------------------+--------+--------------------------+---------+---------+------------------------------------------------------+------+-----------------------------+
  | id | select_type | table                 | type   | possible_keys            | key     | key_len | ref                                                  | rows | Extra                       |
  +----+-------------+-----------------------+--------+--------------------------+---------+---------+------------------------------------------------------+------+-----------------------------+
  |  1 | SIMPLE      | tblbulkreportjobitems | ALL    | fldparticipantid         | NULL    | NULL    | NULL                                                 |  869 | Using where; Using filesort |
  |  1 | SIMPLE      | tblparticipant        | eq_ref | PRIMARY,fldParticipantId | PRIMARY | 4       | medicus_devel.tblbulkreportjobitems.fldparticipantid |    1 | Using where                 |
  +----+-------------+-----------------------+--------+--------------------------+---------+---------+------------------------------------------------------+------+-----------------------------+
  2 rows in set (0.05 sec)
  </code></pre>
  
  <p>Why is it using a filesort still?</p>