Automatic extended statistics to improve performance Posted on April 6, 2017, updated on April 6, 2017 by Yannick JaquierTable of contents Preamble Automatic extended statistics preparation Automatic extended statistics testing References Continue reading
PL/SQL performance tuning with bulk SQL/binding and parallelism Posted on February 14, 2017, updated on March 26, 2021 by Yannick JaquierTable of contents Preamble Setup Classical method Bulk SQL method DBMS_PARALLEL_EXECUTE method Raw results References Continue reading
Incremental statistics on partitioned tables Posted on June 29, 2016, updated on June 29, 2016 by Yannick JaquierTable of contents Preamble Incremental statistics Results References Continue reading
Aggregated global statistics on partitioned tables or not ? Posted on June 1, 2016, updated on May 2, 2018 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 December 6, 2019 by Yannick JaquierTable of contents Preamble Traditional statistics gathering Concurrent statistics testing References Continue reading