Postgres Pro
Downloads
Home   >   mailing lists

Re: Order of tables - Mailing list pgsql-performance

From Robert Klemme
Subject Re: Order of tables
Date
Msg-id BANLkTim1cTqGBYnDnYozHaLWsKrs50g5GQ@mail.gmail.com
Whole thread Raw
In response to Order of tables  (Rishabh Kumar Jain <rishabh.widu@yahoo.com>)
Responses Re: Order of tables  (Rishabh Kumar Jain <rishabh.widu@yahoo.com>)
Re: Order of tables  (Rishabh Kumar Jain <rishabh.widu@yahoo.com>)
Re: Order of tables  (Rishabh Kumar Jain <rishabh.widu@yahoo.com>)
List pgsql-performance
Tree view


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/

pgsql-performance by date:

Previous
From: Samuel Gendler
Date:
Subject: Re: reducing random_page_cost from 4 to 2 to force index scan
Next
From: Heikki Linnakangas
Date:
Subject: Re: Order of tables