Re: When are projections done?

From: Jonathan Lewis <>
Date: Tue, 2 Mar 2010 21:21:15 -0000
Message-ID: <>

"jbdhl" <> wrote in message
>> At the earliest possible moment.
> Could that be directly inside the access method that fetches
> individual rows from the page in the buffer? Or is the projection
> always performed at some point *after* the initial fetch of the
> relevant row(s)?

If you wanted a definite answer you'd have to ask the Oracle programmers. But it wouldn't make sense to copy a row from a buffered block into local memory and then extract the fields from the local copy - so I think you can assume that the copy from the buffered block extracts only the columns needed from the row. (There are aspects of the CPU costing algorithm that tend to confirm this,)


Jonathan Lewis
Received on Tue Mar 02 2010 - 15:21:15 CST

Original text of this message