Re: [PERFORM] Order of tables

2011-05-03 Thread Rishabh Kumar Jain
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 a

Re: [PERFORM] Order of tables

2011-05-03 Thread Rishabh Kumar Jain
Robert Klemme-2 wrote: > > On Thu, Apr 28, 2011 at 11:20 AM, Rishabh Kumar Jain > > 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 na

Re: [PERFORM] Order of tables

2011-05-03 Thread Rishabh Kumar Jain
Robert Klemme-2 wrote: > > On Thu, Apr 28, 2011 at 11:20 AM, Rishabh Kumar Jain > > 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 na

Re: [PERFORM] Order of tables

2011-05-03 Thread Rishabh Kumar Jain
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 arc

Re: [PERFORM] Order of tables

2011-04-29 Thread Rishabh Kumar Jain
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. -- Sent via pgsql-perform

Re: [PERFORM] Order of tables

2011-04-28 Thread Heikki Linnakangas
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

Re: [PERFORM] Order of tables

2011-04-28 Thread Robert Klemme
On Thu, Apr 28, 2011 at 11:20 AM, Rishabh Kumar Jain 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_

[PERFORM] Order of tables

2011-04-28 Thread Rishabh Kumar Jain
How the tables must be ordered in the list of tables in from statement?