Re: Join issue

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: ken(at)scottshill(dot)com
Cc: operationsengineer1(at)yahoo(dot)com, Burak Seydioglu <buraks78(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Join issue
Date: 2006-06-07 00:05:21
Message-ID: 969FFD67-016F-48D5-98C9-BFD5780C8AFB@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Middleton 2006-06-07 05:06:29 Re: How to get list of days between two dates?
Previous Message Kenneth B Hill 2006-06-06 23:53:21 Re: Join issue