title: Oracle SELECT statement slow
body: <p>I'm on a query.</p>
  
  <pre><code>SELECT ttf.default_text
    FROM test_template_field ttf, TEST t
   WHERE ttf.schema_field_id = 2044
  --HERE
     AND ttf.test_template_id = t.test_template_id
     AND t.workflow_node_id IN (
            SELECT wn.workflow_node_id
              FROM lims_sys.workflow_node wn, lims_sys.workflow_user wu
             WHERE wn.workflow_id = wu.workflow_id
               AND wn.workflow_node_type_id = 42
               AND wu.u_external_category IN ('M'))
               group by ttf.DEFAULT_TEXT
  </code></pre>
  
  <p>This works fine, and in 8 seconds I get my result back.
  But if I add another AND function, it will take 28 Minutes before I get my results back.
  Its about this one, his location was "--HERE"</p>
  
  <pre><code>AND ttf.default_text NOT IN ('Preparation Microbiology', 'Other', 'Preparation')
  </code></pre>
  
  <p>I don't know why it's slow.. Can someone help?</p>