Setup database statistics

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

UPDATE STATISTICS ... 

Microsoft™ SQL SERVER offers a similar instruction, but it uses different clauses:

UPDATE STATISTICS ... 

See SQL SERVER documentation for more details.

Solution

Centralize the optimization instruction in a function.