title: Netezza delete using JOIN
body: <p>I have two tables in Netezza. Table A have ~70B records and table B have ~15K records. Delete need to happen on table A however I have to join on 2 columns. My query looks like this</p>
  
  <p>Delete from A where (a.col1, a.col2) in (select col1, col2 from B).</p>
  
  <p>I see plan is very costly and looking for alternative approach. Does netezza supports JOIN ON DELETE? Does anybody have any other approach??</p>