SQL adaptation guide For Genero db 3.6x, 3.8x / Data dictionary |
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
Replace the UPDATE STATISTICS by multiple SET GATHERSTATS statements (one for each table)