Re: DB Query

bskolb wrote:

I'm trying to optimize a query that in the first example is taking too long to run. This is my existing working query: $sql = "SELECT count(*) as cnt, id FROM mYTable WHERE c1 not in (1,16,36) and c2 not in (1,16,36) and c3 not in (1,16,36) and c4 not in (1,16,36) and c5 not in (1,16,36) GROUP BY id"; Is it possible to do something like this instead (This doesn't work of course) $sql = "SELECT count(*) as cnt, id FROM myTable WHERE (c1,c2,c3,c4,c5) not in (1,16,36) GROUP BY id"; Any other suggestions are appreciated, Thanks!

Even if the syntax whould be possible, it whould not help any. SQL server optimize queries before executing them, and your second query would be the same as the first one. What is the column type of c1,c2,c3,c4 and c5? What indexes did you create?