Heikki Linnakangas-3 wrote: > > On 28.04.2011 12:20, Rishabh Kumar Jain wrote: >> How the tables must be ordered in the list of tables in from statement? > > There is no difference in performance, if that's what you mean. (If not, > then pgsql-novice or pgsql-sql mailing list would've be more appropriate) > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com > > -- > Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > I understood that now but I have one more query. In what manner are explicit joins added to improve performence? Are there some rules for it? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Order-of-tables-tp4346077p4369093.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance