> -Original Message-
> From: Stephane Faroult [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 16 October 2003 07:14
> To: Multiple recipients of list ORACLE-L
> Subject: Re: SQL Operation and Row size
>
>
> Daniel Fink wrote:
> >
> > When retrieving data
Daniel Fink wrote:
>
> When retrieving data, does Oracle place just the columns of
> interest into the result set or does it place the entire row in
> the result set (and filter out the columns of interest later)?
>
I'd say just the columns of interest. Can be checked by looking at the
number of
At what step ?
Oracle reads blocks, so from the datafile up to the db_buffer/db_cache its
blocks.
It would be logical that the filtering occurs after the where clause has
chosen the data matching the search criteria, so in the select step which is
the last step of the query operation.
Stephane P
When retrieving data, does Oracle place just the columns of
interest into the result set or does it place the entire row in
the result set (and filter out the columns of interest later)?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Fink
INET: [EMAIL PROTECTE
