case:
original code : where selller_id IN (1) and date >= 2012-01-01
effective code: where date >= 2012-01-01 and selller_id IN (1)
conclusion:
IN constraints makes query very slow.
the sequence of in WHERE clause effect query a lot.
case:
original code : where selller_id IN (1) and date >= 2012-01-01
effective code: where date >= 2012-01-01 and selller_id IN (1)
conclusion:
IN constraints makes query very slow.
the sequence of in WHERE clause effect query a lot.