OPTCOMPIND in informix

alfrednone · #1 (**permalink**) 12-11-09, 05:56

Hi All,

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 .