| From: | "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk> |
|---|---|
| To: | 'John Taylor' <postgres(at)jtresponse(dot)co(dot)uk> |
| Cc: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: How efficient are Views |
| Date: | 2002-06-12 15:37:30 |
| Message-ID: | E2870D8CE1CCD311BAF50008C71EDE8E01F748E7@MAIL_EXCHANGE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Everytime the view is accessed the query is executed.
- Stuart
> -----Original Message-----
> From: John Taylor [mailto:postgres(at)jtresponse(dot)co(dot)uk]
>
> On Wednesday 12 June 2002 16:21, you wrote:
>
> > > A view just re-executes the query.
> > Therefore a view is as efficient as the query it's based upon :)
> > hth,
>
> But, does the query get processed, every time the view is
> accessed, or whenever
> the underlying data is changed ?
>
> If it is the former, then it would be the same as using a subselect:
> SELECT * FROM (SELECT my view query) WHERE blah ...
>
> Thanks
> JohnT
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Taylor | 2002-06-12 15:42:46 | Re: Optimising inside transactions |
| Previous Message | Tom Lane | 2002-06-12 15:36:30 | Re: Optimising inside transactions |