RE: [SQL] Joining bug???? - Mailing list pgsql-sql

From Jackson, DeJuan
Subject RE: [SQL] Joining bug????
Date
Msg-id F10BB1FAF801D111829B0060971D839F4AD59E@cpsmail
Whole thread Raw
Responses Re: [SQL] Joining bug????
List pgsql-sql
> > try making a view.  from what others have said, views save the query
> plan
> > and have usually, at least for me, been _alot_ faster than normal
> queries.
>
>     Views don't save query plans. They are parsetree templates in
>     query rewrite rules.
>
So, could you explain what counts for the speed increase.  Is the parse
stage really that costly?
    -DEJ

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] Operator <> for lseg,lseg bug
Next
From: Daniel Facciolo Pires
Date:
Subject: automatic increment field type