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

Home -> Community -> Usenet -> c.d.o.misc -> Performance effect of number of columns on a select clause?

Performance effect of number of columns on a select clause?

From: Pasi Kovanen <Pasi.Kovanen_at_removethis.iki.fi.invalid>
Date: Mon, 25 Feb 2002 11:35:43 +0200
Message-ID: <a5d0ev$s9p$1@news1.song.fi>


We did some tests using different SELECT clauses and were surprised to found how much the number of columns that were selected affect the performance.

For example, execution time of

    SELECT column1 from foobar
seems to be almost constant whatever the size of data returned in column1 is 20 - 400 bytes (only 5% decrease w/ 400 bytes).

Wheres
SELECT column1, column2, ... column13 from foobar can take even 40% longer though most of the columns are null and returned amount of data is less than the 400 bytes column1 alone.

Is there a way to overcome (or kludge ;) this? Received on Mon Feb 25 2002 - 03:35:43 CST

Original text of this message

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