Depends. If there is more data in select * then yes. Since it has to send
you more data. Also if the columns that you name are contained in an index
then it might just use the index to retrieve the results.
Jim
"mr_oatmeal" <mr_oatmeal_at_hotmail.com> wrote in message
news:t28n0u5uektdf2_at_corp.supernews.com...
> is there any performance difference between
>
> select * from table
> (does this take longer than selecting just one field)
>
> select id from table
>
> seltect id, name from table
> (does adding another field in the select stmnt change performance)
>
> thanks mr_oatmeal
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Tue Nov 28 2000 - 19:50:43 CST
