Take advantage of fragment-level statistics and smarter statistics in IBM Informix
From the developerWorks archives
Date archived: January 11, 2017 | First published: April 21, 2011
Keeping statistics up to date is a regular part of the
maintenance of relational databases. However, running
update statistics itself
incurs overhead. Learn how new features in IBM® Informix® V11.7 help
you to improve efficiency by determining when you really need to run update
statistics. Another enhancement in IBM Informix V11.7 improves efficiency by
letting you gather fragment-level statistics for fragmented tables. Learn how
these enhancements can help you optimize your database and applications.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.