Edition-Based Redefinition (EBR) for online application migration Posted on June 20, 2023 , Modified on June 20, 2023 , by Yannick JaquierTable of contents Preamble Edition-Based Redefinition (EBR) and DBMS_REDEFINITION test case Edition-Based Redefinition (EBR) testing Application preparation for EBR Creating the new edition and new edition objects Testing the new edition and crossedition triggers Using service to point to desired edition DBMS_REDEFINITION for online table redefinition References Read more Oracle DBMS_REDEFINITION, Edition-Based Redefinition (EBR), SQL Leave a comment
Data skipping and row group skipping in action with delta tables Posted on June 1, 2023 , Modified on June 5, 2026 , by Yannick JaquierTable of contents Preamble Data skipping test case Data skipping and row chunk skipping testing References Read more Databricks Tuning Leave a comment
How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023 , Modified on October 13, 2026 , by Yannick JaquierTable of contents Preamble Preparation of the test environment The old legacy technique The alter table switch technique The view technique The synonym technique The schema transfer technique Conclusion References Read more MariaDB, MySQL, Oracle, PostgreSQL, SQL Server Development, SQL Leave a comment
Polymorphic Table Functions (PTF) hands-on Posted on April 20, 2023 , Modified on October 12, 2026 , by Yannick JaquierTable of contents Preamble Polymorphic Table Functions (PTF) basic example Polymorphic Table Functions (PTF) manipulating output Polymorphic Table Functions (PTF) debugging References Read more Oracle Polymorphic Table Functions (PTF), SQL Leave a comment
Citus columnar storage hands-on Posted on March 28, 2023 , Modified on March 10, 2026 , by Yannick JaquierTable of contents Preamble Citus installation Citus columnar storage testing preparation Citus columnar storage testing results References Read more PostgreSQL Development, Tuning 1 comment
Table and scalar SQL macros hands-on Posted on March 3, 2023 , Modified on March 20, 2023 , by Yannick JaquierTable of contents Preamble Table SQL Macros Scalar SQL Macros Conclusion References Read more Oracle Development, SQL Leave a comment