SQL adaptation guide For SQL SERVER 2005, 2008, 2012 / Data dictionary |
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.
Centralize the optimization instruction in a function.