Re: When are projections done?
Date: Tue, 2 Mar 2010 21:21:15 -0000
"jbdhl" <jbirksdahl_at_gmail.com> 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,)
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.comReceived on Tue Mar 02 2010 - 15:21:15 CST