Re: performance versus order of fields in row

Tom Lane wrote:

>"D. Stimits"  writes:
>  
>
>>I'm not looking for an exact answer here, but instead something more 
>>"rule of thumb". If I have a table with many fields, and I retrieving 
>>small groups of fields during a SELECT, whereby the groups of fields are 
>>indexed and/or clustered, will I get a faster select in the left-most 
>>fields, or the right-most fields? Or will it not matter?
>>    
>>
>
>Fields earlier in the table definition (further to the left) are
>marginally faster to access than ones further to the right.  I doubt it
>would be real noticeable unless you had hundreds of fields altogether.
>

Do we still "cache" field offsets for not-nullable-fixed-size columns?


Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #