Posted by Trevor Best on 12/05/05 21:24

pb648174 wrote:
> because you would know exactly which columns were needed in the main
> app, i.e. coumn1,2 and 3 as opposed to "all of them"

All that tells me is that you don't need column4.

Having "select column1, column2, column3 from table1" doesn't
necessarily mean you need column1, column2 and column3 any more or less
than "select *", the code later on will determine those columns that you
need.

You could start with "select c1,c2,c3" then end up not using c2 at all.

[Back to original message]