David Kerr wrote:
create view test as select a,b,c,d,e,f,g from testtable; select a from test; (does the engine retrieve b-g?)
Shouldn't - the query just gets rewritten macro-style. I don't think it eliminates joins if you don't need any columns, but that's not possible without a bit of analysis.
-- Richard Huxton Archonet Ltd -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
