[thelist] MySQL oddness

Matt Warden mwarden at gmail.com
Tue Jan 29 12:46:52 CST 2008

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

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list