Keith Gray <[EMAIL PROTECTED]> writes: > ...but is it true that if you place the filter clause first, > the join will not have to complete the whole table?
PG's planner does not pay attention to the ordering of WHERE clauses; it will do what it thinks best with them in any case. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]