title: Oracle query fast in sqldeveloper, slow in asp.net
body: <p>I want to execute the following query and put it on a gridview in my asp.net app</p>
  
  <pre><code>select *
  from INDICATORS, places, places_sales
  where places_sales.id = places.id
  and 
  INDICATORS.line  in (select line from lines)
  </code></pre>
  
  <p>the lines table has like a 28000 records and INDICATORS like 18000</p>
  
  <p>This query is executed in oracle sql developer in 6 seconds, but in my asp.net application (with oracle dataacess as connector) takes like 20 minutes</p>
  
  <p>Is there a way to optimize my query?</p>