A typical programmer may expect that the predicates are always evaluated in the order that they are specified, but this is not true in database systems. For example, for the following clause, where col11 = 5 and convert(int, col2) = 100 programmers may
