For example, consider the queres: SELECT * FROM table1 WHERE field1=1 AND field2=1;
SELECT * FROM table1 WHERE field2=1 AND field1=1; These two queries are logically equivalent. But in all cases the planner generates a query plan that performs field1=1 condition, and then field2=1 condition, as there is a index on field1. Is it possible to instruct the PostgreSQL query planner to perform field2=1 condition first, and then field1=1 condition? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
