Postgres Pro
Downloads
Home   >   mailing lists

Re: filtering after join - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: filtering after join
Date
Msg-id 200601261759.31184.peter_e@gmx.net
Whole thread Raw
In response to Re: filtering after join  (andrew <andrew.ylzhou@gmail.com>)
Responses Re: filtering after join  (andrew <andrew.ylzhou@gmail.com>)
List pgsql-sql
Tree view 
andrew wrote:
> How will the query planner do for a nesting query? Treat the
> subqueries as multiple queries and then link them together?
> where can I find the information (codes or documents)?

Look at the execution plan using the EXPLAIN command.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Changing the transaction isolation level within the stored
Next
From: "Daniel Caune"
Date:
Subject: [HELP] Defining a function as a procedure