Re: Order of tables

From: Rishabh Kumar Jain <rishabh(dot)widu(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Order of tables
Date: 2011-05-04 05:29:26
Message-ID: 1304486966635-4369091.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Robert Klemme-2 wrote:
>
> On Thu, Apr 28, 2011 at 11:20 AM, Rishabh Kumar Jain
> &lt;rishabh(dot)widu(at)yahoo(dot)com
> &gt; 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rishabh Kumar Jain 2011-05-04 05:30:58 Re: Order of tables
Previous Message Rishabh Kumar Jain 2011-05-04 05:26:10 Re: Order of tables