"Philippe Lang" <philippe.lang@xxxxxxxxxxxxxx> 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 the Postgresql engine?
To the best of my knowledgle, if you PREPARE a query that uses a view,
either explicitly or implicitly via your database driver, the plan
will be cached.
-Doug
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
