developer came by and asked me an interesting question.
If he has a view with 20 columns in it, and he selects a specific column from the view
in his query. Does the engine when accessing the view return all columns? or is it
smart enough to know to just retrive the one?
create view test as
select a,b,c,d,e,f,g from testtable;
select a from test;
(does the engine retrieve b-g?)
pgsql-performance by date
|Next:||From: Richard Huxton||Date: 2009-08-13 16:28:01|
|Subject: Re: Under the hood of views|
|Previous:||From: Matthew Wakeling||Date: 2009-08-13 14:36:15|
|Subject: Re: How to run this in reasonable time:|