[SQL]

2005-10-24 Thread Илья Конюхов
> 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 fie

[SQL]

2005-10-24 Thread Илья Конюхов
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,