Re: Questions on PRIMARY KEY

Hi, > WHERE > col1 > AND col2 > etc... > AND PRIMARYKEY > 0; [...skip...] > I need an explanation of whether what I did is an > optimization or not? Or should i be looking into something > else to actually optimize the query. The best way to optimize it is would be to a

Questions on PRIMARY KEY

Hello all, Need an explanation on this: SELECT col1, col2, ... FROM tbl1 JOIN tbl2 ON (some cond) JOIN tbl3 ON (some cond) . . . WHERE col1 > AND col2 > etc... Running an EXPLAIN o