> Would my query performance be significantly faster/slower using a View as
> opposed to a prepared query using join?
I missed this part. Views and prepared queries are not the same time.
Use of a view still needs to be optimized.
Prepared queries will run the optimization portion on the entire query
including the view segments of it. Think of a view as a MACRO.
Depending on the context of what surrounds it, the view may be executed
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
In response to
pgsql-performance by date
|Next:||From: Bruno Wolff III||Date: 2003-06-01 05:33:39|
|Subject: Re: Index speeds up one row table (why)?|
|Previous:||From: Rod Taylor||Date: 2003-06-01 04:02:39|
|Subject: Re: are views typically any faster/slower than equivilent joins?|