Aggregated global statistics on partitioned tables or not ? Posted on June 1, 2016, updated on February 27, 2025 by Yannick JaquierTable of contents Preamble Partitioned test table Aggregated global statistics Gathered global statistics Global statistics performance comparison References Continue reading
System statistics interaction with database resource manager Posted on May 2, 2016, updated on May 2, 2018 by Yannick JaquierTable of contents Preamble Optimizer differences System statistics References Continue reading
Concurrent statistics activation and gathering Posted on February 3, 2016, updated on July 23, 2024 by Yannick JaquierTable of contents Preamble Traditional statistics gathering Concurrent statistics testing References Continue reading
Data Warehouse performance features implementation Posted on September 23, 2015, updated on May 2, 2018 by Yannick JaquierTable of contents Preamble Data Warehouse test case Star Transformation Enabled Bitmap Join Index Automatic parallelism References Continue reading
MySQL Fabric sharding testing Posted on July 24, 2015, updated on July 14, 2023 by Yannick JaquierTable of contents Preamble MySQL Fabric sharding configuration MySQL Fabric sharding implementation Sharding testing References Continue reading
In-Memory Column Store simple example and performance comparison Posted on April 1, 2015, updated on July 9, 2024 by Yannick JaquierTable of contents Preamble In-memory test case preparation In-Memory testing Conclusion References Continue reading