title: optimize query with minus oracle
body: <p>Wanted to optimize a query with the minus that it takes too much time ... if they can give thanked help.</p>
  
  <p>I have two tables A and B,</p>
  
  <p>Table A: ID, value</p>
  
  <p>Table B: ID</p>
  
  <p>I want all of Table A records that are not in Table B. Showing the value.
  For it was something like:</p>
  
  <pre><code>Select ID, value
  FROM A
  WHERE value&gt; 70
  MINUS
  Select ID
  FROM B;
  </code></pre>
  
  <p>Only this query is taking too long ... any tips how best this simple query?</p>
  
  <p>Thank you for attention</p>