Faster UPDATE STATISTICS LOW operations on large indexes

Friday, 18 November 2011

If you upgrade to IBM Informix Version 11.70xC4, you can generate index statistics based on sampling when you run UPDATE STATISTICS statements in LOW mode. For an index with more than 100 K leaf pages, the gathering of statistics using sampling can increase...

Author: 96QY_Pat_Smith

Find the whole article Faster UPDATE STATISTICS LOW operations on large indexes on the website Appropriate Content: Informix Documentation Team.

< Prev		Next >

Newsflash

IBM intends to offer NoSQL database capabilities inside of DB2 beginning early next year, according to a keynote speaker at IBM Information On Demand 2011.

Title: Best Practices for Embedded Data Management
Date: Thursday, May 24, 2012
Time: 10:30 AM - 12:00 PM (Central Time), 16:30h Germany
Presented By: Pradeep Natarajan - Software Developer (IBM)
Registration: Best Practices for Embedded Data Management

Description:

 
A small footprint, a silent i...