SQL adaptation guide For Oracle Database 9.2, 10.x, 11.x, 12x / Data dictionary |
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.
Centralize the optimization instruction in a function.