RE: Is this a performance issue?

Hi,

  Additionally, by choosing all the columns, the data buffer cache   will also get filled at a faster rate where it need not have to be   that way.

Regards
Rajagopal Venkataramany

On Tue, 25 Jul 2000 10:44:09 -0800, ORACLE-L_at_fatcity.com wrote:

> If the results are going through SQL*Net over the network then less is
> better.
>
> -----Original Message-----
> Kamesh.J.Mantri_at_citicorp.com
> Sent: Tuesday, July 25, 2000 2:24 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Actually this is not a performance issue bcos when Oracle fetches rows
for a
> select it does in with implicit cursor
> which goes row by row not column by column. Even if we mention a single
> col
> it fetches the whole row.
>
> Gurus correct me I am wrong..
>
>
> Kamesh.
>
> -----Original Message-----
> Sent: Monday,July 24, 2000 9:07 PM
> To: ORACLE-L
> Cc: schanna
>
>
> Gurus,
>
> I'm wondering if it's a performance issue if i select all the columns
from
> a table even if you don't require.
>
> Let say I have a table which has about 50 columns in it and i need to
get
> values for only 5-10 columns. So, instead of selecting only these
columns
> I select *.
>
> Any idea if that screws up my performance?
>
>
>
> Santhosh Babu
>
> --
> Author: Channa, Santhosh, SITS
> INET: schanna_at_att.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author:
> INET: Kamesh.J.Mantri_at_citicorp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author: Steve Orr
> INET: sorr_at_arzoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

Regards
Rajagopal Venkataramany