Thread: Order of tables
| How the tables must be ordered in the list of tables in from statement? |
On Thu, Apr 28, 2011 at 11:20 AM, Rishabh Kumar Jain <rishabh.widu@yahoo.com> wrote:
How the tables must be ordered in the list of tables in from statement?
To achieve what? Generally there is no requirement for a particular ordering of relation names in SQL.
Cheers
robert
--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/
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
On what relations are explicit joins added? I don't know when to add explicit joins.-- View this message in context: http://postgresql.1045698.n5.nabble.com/Order-of-tables-tp4346077p4358465.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
Thanks for previous reply my friend. 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-tp4346077p4369082.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
Robert Klemme-2 wrote: > > On Thu, Apr 28, 2011 at 11:20 AM, Rishabh Kumar Jain > <rishabh.widu@yahoo.com > > wrote: > >> How the tables must be ordered in the list of tables in from statement? >> > > To achieve what? Generally there is no requirement for a particular > ordering of relation names in SQL. > > Cheers > > robert > > -- > remember.guy do |as, often| as.you_can - without end > http://blog.rubybestpractices.com/ > Ok I Understood this but there is one more problem friend 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-tp4346077p4369085.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
Robert Klemme-2 wrote: > > On Thu, Apr 28, 2011 at 11:20 AM, Rishabh Kumar Jain > <rishabh.widu@yahoo.com > > wrote: > >> How the tables must be ordered in the list of tables in from statement? >> > > To achieve what? Generally there is no requirement for a particular > ordering of relation names in SQL. > > Cheers > > robert > > > Ok I Understood this but there is one more problem friend 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-tp4346077p4369091.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
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@postgresql.org) > 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.