[Please quote responsibly. There was no need to quote my entire
message back to the list.]
On Jun 16, 2006, at 7:15 , <operationsengineer1@yahoo.com> wrote:
> i need to become mor familiar with views. if i use
> views, will i substantially impair performance?
Short answer: maybe, maybe not
Long answer: benchmark and compare. EXPLAIN ANALYZE is your friend.
For example, compare the EXPLAIN ANALYZE output using the view and
using the whole, explicit query. You'll learn a lot that will only
help you write better queries.
Michael Glaesemann
grzm seespotcode net