A really long time ago, on 2/27/07, Tom Lane <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
