Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    sweden
    Posts
    17

    Post Unanswered: update statistics INFORMIX

    I do have a database which is about 150 GB. Today I use the useual update statisticis.
    In this database there is big tables about 15 - 20 GB, which is fragmented.
    The update statictics takes about 18 houres.

    I would like to know if I run the right update statistics or should I chang it ? at last time I did test to run update statistics high for cople of tables and I did note a faster query result.

    my script is
    update statistics DBNAME

    the test script

    update statistics high for table order;


    Thanks in advance
    Linux

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Have you tried update statistics medium/low -- Each level has its appropriate use - for high, the table should be small.

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Read the following link about the Informix Optimizer and update statistics (for more information on appropriate use of low/medium/high):

    link

  4. #4
    Join Date
    Nov 2003
    Location
    sweden
    Posts
    17
    Originally posted by rnealejr
    Have you tried update statistics medium/low -- Each level has its appropriate use - for high, the table should be small.
    what u mean by samll ? the column size or the how meny record there is the table ?
    Linux

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    Number of rows.

Posting Permissions

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