Setup database statistics

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

UPDATE STATISTICS ...

Oracle has the following instruction to compute database statistics:

ANALYZE ...

See Oracle documentation for more details.

Solution

Centralize the optimization instruction in a function.