title: My query runs faster the second time around, how do i stop that?
body: <p>i am running a query in oracle 10 <code>select A from B where C = D</code>
  B has millions of records and there is no index on C</p>
  
  <p>The first time i run it it takes about 30 seconds, the second time i run the query it takes about 1 second.   </p>
  
  <p>Obviously it's caching something and i want it to stop that, each time i run the query i want it to take 30s - just like it was running for the first time.</p>
  
  <ul>
  <li>i am over-simplifying the issue that i am having for the sake of making the question readable. </li>
  </ul>
  
  <p>Thanks</p>