title: Slow MySql Query: tool to examine and suggest composite index
body: <p>I have a query that joins across multiple tables which has poor performance and so I'm using trial and error techniques to create composite indexes to try and improve the perf based on the columns I'm filtering on but I'm not getting the desired results.
  I am using The EXPLAIN plan to try and determine a suitable indexing strategy.</p>
  
  <p>Can anyone suggest another tool that can help with this?</p>