On 1/29/08, r937 <rudy at r937.com> wrote: > on the other hand, specifying SELECT * when you don't need all the columns > is what will increase query execution time, and the difference can be > substantial Rudy, this is the part I am contesting (in fact I had not even thought about the parsing difference). Specifying a subset of columns will require a projection[1]. Or are you suggesting that the database will perform a projection even if the column list is the full set? [1] http://en.wikipedia.org/wiki/Projection_(relational_algebra) -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.