Take advantage of fragment-level statistics and smarter statistics in IBM Informix

From the developerWorks archives

Nita Dembla

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=647743
ArticleTitle=Take advantage of fragment-level statistics and smarter statistics in IBM Informix
publish-date=04212011