Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    48

    Question Unanswered: OPTCOMPIND in informix

    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 .

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  3. #3
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •