Re: performance question (select * vs select field)

From: Tom Leary <tleary1_at_uswest.net>
Date: Sat, 2 Dec 2000 17:01:09 -0800
Message-ID: <eSfW5.648$tR6.350380@news.uswest.net>

Yes, it makes a difference. Oracle must create an implicit cursor to hold the return values from your query, and * requires a variable to be created and populated for each row, rather than 1 variable holding 1 field. Also, it takes longer to return the results to the client across the network.

HTH,
DBA Tom

"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 Sat Dec 02 2000 - 19:01:09 CST