Doing the following query:explain analyze SELECT * FROM my.tablename WHERE node = '1234567890' AND date BETWEEN '2005-03-27' AND NOW() ORDER BY id DESC
ORDER BY node,id is forcing the planner to use the right index. Thanks, Poul ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
