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