Hello, Tim!

Wednesday, October 9, 2013, 3:29:09 PM, you wrote:

TW> I've got a query containing

TW> ... WHERE ... (MYFIELD in (1,3,4,5,7,8,9,11,12,13))

TW> which runs horribly slowly, because (quite reasonably) the query

use
myfield+0 in (1,3,4,5,7,8,9,11,12,13)
so, it will not use index on myfield, and other indices can give
better performance.


--
Dmitry Kuzmenko, www.ib-aid.com