Setup database statistics

Informix® provides a special instruction to compute database statistics in order to help the optimizer determine the best query execution plan:

UPDATE STATISTICS ...

Genero db provides the following instruction to collect statistics:

SET GATHERSTATS tablename

Solution

Replace the UPDATE STATISTICS by multiple SET GATHERSTATS statements (one for each table)