Re: Order of tables - Mailing list pgsql-performance

From Rishabh Kumar Jain
Subject Re: Order of tables
Date
Msg-id 1304486770759-4369085.post@n5.nabble.com
Whole thread Raw
In response to Re: Order of tables  (Robert Klemme <shortcutter@googlemail.com>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Willy-Bas Loos
Date:
Subject: Re: [PERFORMANCE] expanding to SAN: which portion best to move
Next
From: Rishabh Kumar Jain
Date:
Subject: Re: Order of tables