Keith Gray <keith@xxxxxxxxxxxx> 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 majordomo@xxxxxxxxxxxxxx
|
Try Searching:
servers, voip, java, networking, microsoft ...
|
|
|
|