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 you prepare "SELECT * FROM my_view" then the plan for that will be cached. In general though, the query will be planned each time.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
