Re: Is it really a performance issue ?

Well, I'm making a ( hopefully ) educated guess on this.

The rows will be read regardless of the columns you select.

There will be slightly more overhead to stuff more columns into a cursor, but it is likely negligible.

If you are transporting the data outside of the database, such as to a remote location via SQL*Net, then selecting fewer columns will have a positive impact on performance.

Maybe you could test this out and let us know the results?

Jared

On Fri, 21 Jul 2000, Channa, Santhosh, SITS wrote:

>
>
> > 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).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Sat Jul 22 2000 - 21:56:08 CDT