var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: OPTCOMPIND in informix
we are merging 2 tables “tab1” and “tab2” in the schema of tab1.
After doing the merge, the query on the “field1” field of tab1 (index on field1) is very slow.
we modified the “OPTCOMPIND” variable in the onconfig file from 2 to 0.
Once modified, the query went very fast and the response time was reduced from 5-6 minutes to less than 1 second.
is there any inconvenience if modifying OPTCOMPIND from 2 to 0 ??
is there any document describing OPTCOMPIND and when it should be changed ?
Thank you .