My rule of thumb is to partition my data sets, to make sure the conditional has the same result in as long a row as possible.