logo       
Google Custom Search
    AddThis Social Bookmark Button

Re: 2 Selects 1 is faster, why?: msg#00379

Subject: Re: 2 Selects 1 is faster, why?
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 ...
<Prev in Thread] Current Thread [Next in Thread>