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

Have you tried update statistics medium/low -- Each level has its appropriate use - for high, the table should be small.

Read the following link about the Informix Optimizer and update statistics (for more information on appropriate use of low/medium/high):

link

what u mean by samll ? the column size or the how meny record there is the table ?

Number of rows.