Re: Join issue - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: Join issue
Date
Msg-id 969FFD67-016F-48D5-98C9-BFD5780C8AFB@seespotcode.net
Whole thread Raw
In response to Re: Join issue  (Kenneth B Hill <ken@scottshill.com>)
Responses Re: Join issue
List pgsql-sql
On Jun 7, 2006, at 8:53 , Kenneth B Hill wrote:

> Make a "view" with a
> query, then perform a query using the view, etc. , then drop all views
> in the SQL script. This may make the entire operation perform faster.

I don't know how using a view would improve performance. However, it  
may make the overall query more tractable by encapsulating portions  
of it using views.

Michael Glaesemann
grzm seespotcode net






pgsql-sql by date:

Previous
From: Kenneth B Hill
Date:
Subject: Re: Join issue
Next
From: Tim Middleton
Date:
Subject: Re: How to get list of days between two dates?