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