I'm running a query along the lines of 'SELECT * FROM Table WHERE Field IN (a, b, c, ...)', where my IN list contains 1000 entries. When I run this query through Visual Studio, it's instant, but when I run it using SqlCeCommand.ExcuteReader(),
it takes minutes. I copied the query from code into the query window, so it's identical. The field for the IN is indexed, but the table is empty. Anyone have any ideas on this one?
View Complete Post