Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Posts
    1

    Unanswered: Large index - informix 9.4.

    Hello,

    I have large table obout 1 milion rows - 80 GB.

    table_AAAA

    Column name Type Nulls

    id_name char(10) no
    seria_name char(10) no
    value integer no

    For this table i have index:

    create unique index i_table_AAAA on table_AAAA (id_name,seria_name) using btree


    Table table_AAAA is not increased. But index i_table_AAAA after four-five days increased about 1 GB.

    It is normal situation ??
    How i can monitoring this index ??

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    Hi,

    Monitoring a table and its indexes can be done with:
    Code:
    oncheck -pt database:table
    An what happens with the index after issuing a
    Code:
    UPDATE STATISTICS FOR TABLE table;
    statement?

    Regards
    Last edited by Tyveleyn; 08-18-07 at 07:05.

  3. #3
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    force execute a b-tree check with onmode
    i don't remember if this command works in 9.4 ...
    ________________________________________
    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
  •