var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: LOBs INLINE column
os aix 7.1
recently I alter LOBs column to INLINE named tab_inline and started some test . I created copy of table before INLINE named tab_NOT_inline
1- Loaded 10000 records all outinline (length of LOB > Length INLINE)
tab_inline 50 sec
tab_NOT_inline 30 sec
2- IMPORTED the same record
tab_inline 45 sec
tab_NOT_inline 70 sec
could you please help me to understand why in LOAD operation we have slow performance and in IMPORT we have improvement.
according to IBM document coverting to INLINE should improve INSERTION anyway.
Thank you in advance for your help.