title: Improving performance SQL
body: <p>Any way to customize below SQL to improve performance where same inner query is running for more than once?</p>
  
  <pre><code>DELETE FROM interactionrel 
  WHERE  ( from_interact_id IN(SELECT interaction_id 
                               FROM   interaction 
                               WHERE  instance_pk = ?) ) 
          OR ( to_interact_id IN(SELECT interaction_id 
                                 FROM   interaction 
                                 WHERE  instance_pk = ?) ) 
  </code></pre>