title: Toad: queries almost alike, one finishes fast, other one doesn't finish at all
body: <p>I am using Toad to query an Oracle database.</p>
  
  <p>I have two (complex) queries that are completely the same, only difference is in the where clause. I can not shown them due to privacy at my job.</p>
  
  <p>Query 1: a part of the where clauses states : where account is in (1,2,3,4,5) (these are dummy numbers) : this query finished fast (2 minutes 30 seconds)</p>
  
  <p>Query 2: that same part of the where clause states: where account is in (1,2,3) : this query never finishes.</p>
  
  <p>Apart from the above, the queries are completely the same. They do however comprise of a lot of other joins and conditions. All the same.</p>
  
  <p>I don't get what is going on here, I would think query 2 needs to finish faster since it doesn't have '4' or '5' in its clause. </p>
  
  <p>Thanks!</p>