Whilst I often use views for convenience, is there any performance
advantage at all in using a view rather than running the same query
directly on the tables themselves?
Is it quicker to run a full complex query rather than run a much simpler
query on a view? (Hope that makes sense)
Robert John Shepherd.
The UK's BIGGEST Online DVD Magazine
For a copy of my Public PGP key, email: pgp(at)robertsworld(dot)org(dot)uk
pgsql-performance by date
|Next:||From: Richard Huxton||Date: 2003-04-15 16:29:45|
|Subject: Re: [PERFORM] Yet Another (Simple) Case of Index not used|
|Previous:||From: Will LaShell||Date: 2003-04-15 15:40:05|
|Subject: Re: for help!|