J
James Palmer
Guest
Is it possible that table.field contains a non-integer value somewhere? That being said, this query is really bad. As soon as you put a function on the left hand side of the predicate the compiler cannot select an index properly and you'll get a whole table read.
Continue reading...
Continue reading...