Advanced Database Feature Guide


Using Column/Row-Wise Binding

Column-Wise Binding and Row-Wise Binding referred to how the memory used to fetch row data into memory is organized. By default, the DB2 Advanced Database feature uses column-wise binding since performance testing has shown it be more efficient. However, this option can be altered by sending the result table object, which is returned by executing a select statement, the useColumnBinding or useRowBindingmessage. These methods must be sent to the result table object prior to accessing any row data.

result := connection executeSql: 'SELECT * FROM TEMP'. 
result useColumnBinding. 
result rows. 
result := connection executeSql: 'SELECT * FROM TEMP'. 
result useRowBinding. 
result rows. 
 

Although under Smalltalk there is no perceivable benefits to using row binding, it has been mentioned here for the sake of completeness.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]