RE: [SQL] Joining bug????

From: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
To: jwieck(at)debis(dot)com, caffeine(at)toodarkpark(dot)org
Cc: selkovjr(at)mcs(dot)anl(dot)gov, pierre(at)desertmoon(dot)com, pgsql-sql(at)postgreSQL(dot)org
Subject: RE: [SQL] Joining bug????
Date: 1998-10-28 17:11:51
Message-ID: F10BB1FAF801D111829B0060971D839F4AD59E@cpsmail
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jackson, DeJuan 1998-10-28 17:49:00 RE: [SQL] Joining bug????
Previous Message Bruce Momjian 1998-10-28 16:05:26 Re: [SQL] Operator <> for lseg,lseg bug