title: How to optimize the performance of this query
body: <p>I have a query that takes about 5 minutes to complete. Is there any way to improve it? My database contains about 300 000 records in each of the tables.</p>
  
  <p>My query: </p>
  
  <pre><code>SELECT *
  FROM Client_Master B
  INNER JOIN Client_Bank C ON B.client_id=C.Client_Id
  LEFT JOIN CL_Client_Bank_Details_Dropout A ON A.client_id=B.Client_Id
   WHERE B.Status = 'D'
   AND A.Client_Id IS NULL
  </code></pre>