> 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
very differently.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
