Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> performance question (select * vs select field)

performance question (select * vs select field)

From: mr_oatmeal <mr_oatmeal_at_hotmail.com>
Date: Wed, 29 Nov 2000 01:30:06 -0000
Message-ID: <t28n0u5uektdf2@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:30:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US