A really long time ago, on 2/27/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Usually what you want to think about for something
> like this is plan optimization, ie, what order are the tables joined in
> and with what join methods.
How exactly can you control the join order? I have cases where the
explain data indicates that the planner is picking a very inefficient
way to get the data, (i.e. joining two very big tables in their
entirety, then joining that to a 3rd with maybe 10 rows yielding maybe
30). I'd love to have some more determinacy in dealing with the
planner on complex queries...
Dave