From: Rishabh Kumar Jain <rishabh.widu@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: Order of tables
Date: Tue, 3 May 2011 22:26:10 -0700 (PDT)
Message-ID: <1304486770759-4369085.post@n5.nabble.com> (raw)
In-Reply-To: <BANLkTim1cTqGBYnDnYozHaLWsKrs50g5GQ@mail.gmail.com>
References: <361406.75324.qm@web137010.mail.in.yahoo.com>
<BANLkTim1cTqGBYnDnYozHaLWsKrs50g5GQ@mail.gmail.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rishabh.widu@yahoo.com
Subject: Re: Order of tables
In-Reply-To: <1304486770759-4369085.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox