Re: [GENERAL] Execution plan caching

2007-10-02 Thread Douglas McNaught
"Philippe Lang" <[EMAIL PROTECTED]> writes: > Hi, > > I have recently used the MS SQL Server 2005 database, and found out that > there is no mecanism where an execution plan can be reused between two > successive calls to a view. This is only true with stored procedures. > > Is that also true with

Re: [GENERAL] Execution plan caching

2007-10-02 Thread Richard Huxton
Philippe Lang wrote: Hi, I have recently used the MS SQL Server 2005 database, and found out that there is no mecanism where an execution plan can be reused between two successive calls to a view. This is only true with stored procedures. Is that also true with the Postgresql engine? Well, if

[GENERAL] Execution plan caching

2007-10-02 Thread Philippe Lang
Hi, I have recently used the MS SQL Server 2005 database, and found out that there is no mecanism where an execution plan can be reused between two successive calls to a view. This is only true with stored procedures. Is that also true with the Postgresql engine? Philippe --