Data Partitioning with Informix Dynamic Server

(Andrew Ford) One of the engines that I manage contains a particularily nasty table. Let me know if this sounds familiar: This troublemaker is a history table that stores the details of each of the 2 million transactions our platform processes each day. The rows are wide, weighing in at over 900 bytes per row, letting me fit a whopping 2 rows per 2K page. The table contains the most recent six months of history; anything older than six months must be removed nightly to make room for tomorrow's data.

Read More >>