Does the number of conditions in WHERE clause, affect the query execution time?

SQL++
2

@iwanna_ster ,
Which is one faster. you mentioned first one quicker and later first to be slower?

Your queries using ANY clause,

  1. depends on relation array size. If the matching condition is at the end of the array it needs to evaluate until matching condition.
  2. If you have multiple ANY clause each one has to evaluate.

If it using array index and multiple ANY using same array, you are asking match more than one element in different position of the array. Depends on what is it can use IntersectScan. some times it can take time.

If using EE execute queries in Query Work bench and goto plan Text which gives profile info (timings, #ItemsIn/ItemsOut for each operator and see where took time). Checkout links in Filter taking too long - #3 by pccb